?? Unix ?????: 1484289773
?????? ??????
Unix ?? ?? POSIX ?????? ?? Unix ?????? 1970? 1? 1? 00:00:00?? ???? ??? ???? ?? ?? ?????. ???? ?? ? ??? ? ? ????. Unix ?????? Unix ??? ? Unix ?? ????? ??? ?? ?? ?? ????? ?? ?????. ???? Unix ???? ?????? 32?? ??? ????? 2038? 1? 19?? ??? ??? ? ????(Y2038 ??).
?? ????? ??? ?? Unix ?????(Unix ?????)? ?? ??? ??????
| ?? | ?? |
| ?????? | Math.round(new Date().getTime()/1000) getTime()? ??? ??? ?? ????? |
| ??????? .NET/C# | epoch = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000 |
| MySQL | SELECT unix_timestamp(now()) |
| ? | ?? |
| PHP | ??() |
| ?????SQL | SELECT ??(epoch FROM now()) |
| ??? | ?? ???? ?? ??? time.time() |
| ?? | Unix ????? ????: Time.now ?? Time.new Unix ????? ??: Time.now.to_i |
| SQL ?? | ?? ??(s, '1970-01-01 00:00:00', GETUTCDATE()) |
| ???/??? | ?? +%s |
| VB????/ASP | DateDiff("s", "1970? 1? 1? 00:00:00", Now()) |
| ?? ?? ?? (Perl? ???? ??? ??) |
??? ??: perl -e "print time" |
Unix ?????(Unix timestamp) → ?? ??? ?? ????? ??? ???? ??? ??????
| ?? | ??? ?? = ??? java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(Unix ????? * 1000)) |
| ?????? | First var unixTimestamp = new Date(Unix timestamp * 1000) Then commonTime = unixTimestamp.toLocaleString() |
| ??? | date -d @Unix ????? |
| MySQL | from_unixtime(Unix ?????) |
| ? | First ? $time = Unix ????? Then ? ($sec, $min, $hour, $day, $month, $year) = (localtime($time))[0,1,2, 3,4,5,6] |
| PHP | date('r', Unix ?????) |
| ?????SQL | ??? '???'? ??? ????? ?? + Unix ?????) * ?? '1?'; |
| ??? | ?? ???? ?? ??? time.gmtime(Unix ?????) |
| ?? | Time.at(Unix ?????) |
| SQL ?? | DATEADD(s, Unix ?????, '1970-01-01 00:00:00') |
| VB????/ASP | DateAdd("s", Unix ?????, "01/01/1970 00:00:00") |
| ?? ?? ?? (Perl? ???? ??? ??) |
??? ??: perl -e "print scalar(localtime(Unix timestamp))" |
?? ?? → Unix ?????(Unix timestamp)? ?? ????? ??? ??? ??????
| ?? | ? epoch = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").parse("01/01/1970 01:00:00"); |
| ?????? | var commonTime = new Date(Date.UTC(year, month - 1, day, hour, ?, ?)) |
| MySQL | SELECT unix_timestamp(time) ?? ??: YYYY-MM-DD HH:MM:SS ?? YYMMDD ?? YYYYMMDD |
| ? | First Time::Local? ???? Then my $time = timelocal($sec, $min, $hour, $day, $month, $year); |
| PHP | mktime(?, ?, ?, ?, ?, ?) |
| ?????SQL | SELECT extract(epoch FROM ??('YYYY-MM-DD HH:MM:SS')); |
| ??? | First ???? ?? Then int(time.mktime(time.strptime('YYYY-MM-DD HH:MM:SS', '%Y-%m-%d %H:%M:% S'))) |
| ?? | Time.local(?, ?, ?, ??, ?, ?) |
| SQL ?? | ?? ??(s, '1970-01-01 00:00:00', time) |
| ???/??? | date +%s -d"1970? 1? 1? 00:00:01" |
| VB????/ASP | DateDiff("s", "1970? 1? 1? 00:00:00", time) |
