Unix Timestamp → Beijing Time
Beijing Time → Unix Timestamp
Our Unix Timestamp Converter allows you to convert Unix timestamps into standard format Beijing time and vice versa. This tool makes it easy to work with time data in both Unix timestamp and human-readable formats.
Using our Unix Timestamp Converter is straightforward:
Key features of our Unix Timestamp Converter include:
Our Unix Timestamp Converter is a reliable tool for anyone needing to convert time data between Unix timestamps and standard Beijing time formats.
What is Unix Timestamp (Unix timestamp): A timestamp refers to the total number of seconds from 00:00:00 on January 1, 1970, GMT (08:00:00 on January 1, 1970, Beijing Time) 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 timestamp: $unixtime = strtotime($datetime); (www.1024xk .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 use time.time() |
| Ruby | Retrieve 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()) |
| 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 | 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, '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) |
| 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))[0,1,2,3,4,5,6] |
| PostgreSQL | SELECT TIMESTAMP WITH TIME ZONE 'time' + 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") |
Links: google