Timestamp Unix (timestamp Unix) → Waktu Beijing
Waktu Beijing → Timestamp Unix (timestamp Unix)
Alat konversi timestamp Unix, yang dapat mengkonversi timestamp Unix ke waktu Beijing dalam format standar, dan juga dapat mengkonversi waktu Beijing dalam format standar ke timestamp UNIX;
Apakah timestamp Unix (timestamp Unix): Timestamp mengacu pada jumlah total detik dari Waktu Greenwich Mean di bulan 1, 1970 di 00:00:00 (waktu Beijing pada bulan 1, 1970 di 08:00:00) sampai saat ini.
Contoh Penggunaan Unixtime di PHPApakah itu?
Dapatkan timestamp saat ini:$time = time (); Konversi ke waktu Beijing:$datetime = date ('Y-m-d H: i: s', $time); Konversi ke timestamp:$Unixtime = strtotime ($datetime);(www.webmastertoolbag. com)
| PHP | Waktu () |
| Java | Waktu |
| JavaScript | Math.round (new Date ().getTime ()/1000) getTime () mengembalikan nilai dalam milidetik |
| .NET/C# | Waktu = (DateTime.Now. ToUniversalTime (). Ticks - 621355968000000000)/10000000 |
| MySQL | SELECT unix_timestamp (now ()) |
| Perl | Waktu |
| PostgreSQL | SELECT extract (waktu FROM now ()) |
| Python | Impor waktu pertama dan lalu time.time () |
| Ruby | Dapatkan timestamp Unix: Time.now atau Time.new Tampilkan timestamp Unix: 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", Saat Ini () |
| PHP | MKTime (hours, minutes, seconds, 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) Format waktu: 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 | 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 and 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) |
