Developer Tools Developer Tools
Unix timestamp, Unix timestamp conversion tool
Current timestamp
Beijing Time

Unix timestamp(Supports input)→Time

Unix timestamp
Time

Time(Supports input)→Unix timestamp

Time
Unix timestamp

Unix Timestamp Conversion Tool

Unix timestamp conversion tool, capable of converting Unix timestamps to standard Beijing Time format, and also converting standard Beijing Time format to UNIX timestamps;

What is a Unix timestamp: A timestamp refers to the total number of seconds elapsed since January 1, 1970, 00:00:00 GMT (January 1, 1970, 08:00:00 Beijing Time) up to the present moment.

PHP Example: Using Unix Timestamp：

Get the current timestamp:$time = time(); Convert to Beijing Time:$datetime = date('Y-m-d H:i:s',$time); Convert to timestamp:$unixtime = strtotime($datetime);

1. Methods to get current Unix timestamp in different programming languages and databases:

PHP time()
Java time
JavaScript Math.round(new Date().getTime()/1000)
getTime() returns milliseconds
.NET / C# time = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000
MySQL SELECT unix_timestamp(now())
Perl time
PostgreSQL SELECT extract(time FROM now())
Python import time then time.time()
Ruby Get Unix timestamp: Time.now or Time.new
Display Unix timestamp: Time.now.to_i
SQL Server SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())
Unix / Linux date +%s
VBScript / ASP DateDiff("s", "01/01/1970 00:00:00", Now())

2. Convert normal time to Unix timestamp in different programming languages and databases:

PHP mktime(hour, minute, second, day, month, year)
Java long datetime = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").parse("01/01/1970 01:00:00");
JavaScript var commonTime = new Date(Date.UTC(year, month - 1, day, hour, minute, second))
MySQL SELECT unix_timestamp(time)
Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD
Perl use Time::Local then my $time = timelocal($sec, $min, $hour, $day, $month, $year);
PostgreSQL SELECT extract(datetime FROM date('YYYY-MM-DD HH:MM:SS'));
Python import time then int(time.mktime(time.strptime('YYYY-MM-DD HH:MM:SS', '%Y-%m-%d %H:%M:%S')))
Ruby Time.local(year, month, day, hour, minute, second)
SQL Server SELECT DATEDIFF(s, '1970-01-01 00:00:00', datetime)
Unix / Linux date +%s -d"Jan 1, 1970 00:00:01"
VBScript / ASP DateDiff("s", "01/01/1970 00:00:00", datetime)

3. Convert Unix timestamp to normal time (Year-Month-Day Hour:Minute:Second) in different programming languages and databases:

PHP date('r', Unix timestamp)
Java String datetime = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(Unix timestamp * 1000))
JavaScript var unixTimestamp = new Date(Unix timestamp * 1000) then commonTime = unixTimestamp.toLocaleString()
Linux date -d @Unix timestamp
MySQL from_unixtime(Unix timestamp)
Perl my $time = Unix timestamp then my ($sec, $min, $hour, $day, $month, $year) = (localtime($time))[0,1,2,3,4,5,6]
PostgreSQL SELECT TIMESTAMP WITH TIME ZONE 'time' + Unix timestamp) * INTERVAL '1 second';
Python import time then time.gmtime(Unix timestamp)
Ruby Time.at(Unix timestamp)
SQL Server DATEADD(s, Unix timestamp, '1970-01-01 00:00:00')
VBScript / ASP DateAdd("s", Unix timestamp, "01/01/1970 00:00:00")
Footprints:

Developer Tools

Links： Developer Tools