Unix Timestamp → Beijing Time
Beijing Time → Unix Timestamp
The Unix Timestamp Conversion Tool can convert Unix timestamps to standard format Beijing Time, and can also convert standard format Beijing Time to Unix Timestamp;
What is Unix Timestamp (Unix timestamp): A timestamp refers to the total number of seconds from Greenwich Mean Time January 1, 197, 00:00:00 (Beijing Time January 1, 197, 8:00:00) to the present. PHP Example Usage of Unixtime: Get the current timestamp: $time = time(); Convert to Beijing Time: $datetime = date('Y-m-d H:i:s',$time); Convert to a timestamp: $unixtime = strtotime($datetime); (www.pcjson.com)
| PHP | time() |
| Java | time |
| JavaScript | Math.round(new Date().getTime()/1000) getTime() returns the value in milliseconds |
| .NET / C# | time = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000 |
| MySQL | SELECT unix_timestamp(now()) |
| Perl | time |
| PostgreSQL | SELECT extract(time FROM now()) |
| Python | First 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, '197-1-1 00:00:00', GETUTCDATE()) |
| Unix / Linux | date +%s |
| VBScript / ASP | DateDiff("s", "1/1/197 00:00:00", Now()) |
| PHP | mktime(hour, minute, second, day, month, year) |
| Java | long datetime = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").parse("1/1/197 1: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 | First 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 | First 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, '197-1-1 00:00:00', datetime) |
| Unix / Linux | date +%s -d"Jan 1, 197 00:00:1" |
| VBScript / ASP | DateDiff("s", "1/1/197 00:00:00", datetime) |
| 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 | First var unixTimestamp = new Date(Unix timestamp * 1000) then commonTime = unixTimestamp.toLocaleString() |
| Linux | date -d @Unix timestamp |
| MySQL | from_unixtime(Unix timestamp) |
| Perl | First my $time = Unix timestamp then my ($sec, $min, $hour, $day, $month, $year) = (localtime($time))[,1,2,3,4,5,6] |
| PostgreSQL | SELECT TIMESTAMP WITH TIME ZONE 'epoch' + (Unix timestamp) * INTERVAL '1 second'; |
| Python | First 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") |
Friendship link： Online Tool Network masters tool Calculation Assistant mathematical calculator ipsaya Random IP Strong Random Password Generator 2 to the power of what is 1/64 Globe Ask hello wordl Live Clock Numbers to Letters Pokemon Guide Snail Bob Red Light Green Light Game Excel Game Block Blast Unblocked Incredibox Sprunki Today Lucky Number Military Time Chart Chronological Age Calculator 12 Weeks From Today Weeks From Today Bottleneck Calculator Letters to Numbers