Convierte timestamps Unix en fechas legibles o fechas en tiempo epoch. Inspecciona logs, APIs, bases de datos y valores temporales.
Unix Timestamp
Beijing Time Unix Timestamp
The Unix Timestamp conversion tool allows for the conversion of Unix Timestamps to Beijing time in the standard format or to UNIX timetamps in the standard format;
(a) What is a UNIX timestamp: a time stamp is the total number of seconds from 0100 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 01/01 1970 Beijing time) GMT to the present.
PHP for example Unixtime：
Other Organiser$time = time(); Convert to Beijing time:$datetime = date('Y-m-d H:i:s',$time); Convert to time stamp:$unixtime = strtotime($datetime);（www.pcjson.com）
| PHP | time() |
| Java | time |
| JavaScript | Math.round(new Date().getTime()/1000) getTime() returns 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 and then time.time() |
| Ruby | Get UNIX Timestamp: Time.now or Time.new Show Unix time stamp: 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: YYY-MM-DD HH:MM:SS or YYMMDD or YYYMMDD |
| Perl | First, use Time: Local and 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 and then int (time.mktime (`YYYY-MM-DD HH:SM:SS', '%Y-%m-%d:%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) and then commonTime = unixTimestring() |
| Linux | date -d @Unix timestamp |
| MySQL | from_unixtime(Unix timestamp) |
| Perl | My $time = Unix timestamp and my ($sec, $min, $hour, $day, $month, $year) = (localtime) [0,1,2,3,4,5,5] |
| PostgreSQL | SELECT TIMESTAMP WITH TIME ZONE 'time' + Unix timestamp) * INTERVAL '1 second'; |
| Python | First Import time and then time. |
| 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") |