各种编程语言中unixtime跟普通时间的转换方法 【转+修改】

各种编程语言中unixtime和普通时间的转换方法 【转+修改】

?

?

如何在不同编程语言中获取现在的Unix时间戳(Unix timestamp)？JavatimeJavaScriptMath.round(new Date().getTime()/1000)
getTime()返回数值的单位是毫秒Microsoft .NET / C#epoch = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000MySQLSELECT unix_timestamp(now())PerltimePHPtime()PostgreSQLSELECT extract(epoch FROM now())Python先?import time?然后?time.time()Ruby获取Unix时间戳：Time.now?或?Time.new
显示Unix时间戳：Time.now.to_iSQL ServerSELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())Unix / Linuxdate +%sVBScript / ASPDateDiff("s", "01/01/1970 00:00:00", Now())其他操作系统
(如果Perl被安装在系统中)命令行状态：perl -e "print time"如何在不同编程语言中实现Unix时间戳(Unix timestamp) → 普通时间？特别注意：那个1000后面有一个L！！！JavaString date = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(Unix timestamp?* 1000L))JavaScript先?var unixTimestamp = new Date(Unix timestamp?* 1000)?然后?commonTime = unixTimestamp.toLocaleString()Linuxdate -d @Unix timestampMySQLfrom_unixtime(Unix timestamp)Perl先?my $time =?Unix timestamp?然后?my ($sec, $min, $hour, $day, $month, $year) = (localtime($time))[0,1,2,3,4,5,6]PHPdate('r',?Unix timestamp)PostgreSQLSELECT TIMESTAMP WITH TIME ZONE 'epoch' +?Unix timestamp) * INTERVAL '1 second';Python先?import time?然后?time.gmtime(Unix timestamp)RubyTime.at(Unix timestamp)SQL ServerDATEADD(s,?Unix timestamp, '1970-01-01 00:00:00')VBScript / ASPDateAdd("s",?Unix timestamp, "01/01/1970 00:00:00")其他操作系统
(如果Perl被安装在系统中)命令行状态：perl -e "print scalar(localtime(Unix timestamp))"如何在不同编程语言中实现普通时间 → Unix时间戳(Unix timestamp)？Javalong epoch = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").parse("01/01/1970 01:00:00");JavaScriptvar commonTime = new Date(Date.UTC(year,?month?- 1,?day,?hour,?minute,second))MySQLSELECT unix_timestamp(time)
时间格式: YYYY-MM-DD HH:MM:SS 或 YYMMDD 或 YYYYMMDDPerl先?use Time::Local?然后?my $time = timelocal($sec, $min, $hour, $day, $month, $year);PHPmktime(hour,?minute,?second,?day,?month,?year)PostgreSQLSELECT extract(epoch FROM date('YYYY-MM-DD HH:MM:SS'));Python先?import time?然后?int(time.mktime(time.strptime('YYYY-MM-DD HH:MM:SS', '%Y-%m-%d %H:%M

?

?

来源：http://tool.chinaz.com/Tools/unixtime.aspx#

查看更多 下一篇