资源描述：
《各种语言时间戳转换方法.docx》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、时间戳转换如何在不同编程语言中获取现在的Unix时间戳(Unixtimestamp)？JavatimeJavaScriptMath.round(newDate().getTime()/1000)getTime()返回数值的单位是毫秒Microsoft.NET/C#epoch=(DateTime.Now.ToUniversalTime().Ticks-621355968000000000)/10000000MySQLSELECTunix_timestamp(now())PerltimePHPtime()PostgreSQLSELECTextract(epochFROMnow())Python先
2、importtime然后time.time()Ruby获取Unix时间戳：Time.now或Time.new显示Unix时间戳：Time.now.to_iSQLServerSELECTDATEDIFF(s,'1970-01-0100:00:00',GETUTCDATE())Unix/Linuxdate+%sVBScript/ASPDateDiff("s","01/01/197000:00:00",Now())其他操作系统(如果Perl被安装在系统中)命令行状态：perl-e"printtime"如何在不同编程语言中实现Unix时间戳(Unixtimestamp)→普通时间？JavaStrin
3、gdate=newjava.text.SimpleDateFormat("dd/MM/yyyyHH:mm:ss").format(newjava.util.Date(Unixtimestamp*1000))JavaScript先varunixTimestamp=newDate(Unixtimestamp*1000)然后commonTime=unixTimestamp.toLocaleString()Linuxdate-d@UnixtimestampMySQLfrom_unixtime(Unixtimestamp)Perl先my$time=Unixtimestamp然后my($sec,$min
4、,$hour,$day,$month,$year)=(localtime($time))[0,1,2,3,4,5,6]PHPdate('r',Unixtimestamp)PostgreSQLSELECTTIMESTAMPWITHTIMEZONE'epoch'+Unixtimestamp)*INTERVAL'1second';Python先importtime然后time.gmtime(Unixtimestamp)RubyTime.at(Unixtimestamp)SQLServerDATEADD(s,Unixtimestamp,'1970-01-0100:00:00')VBScript/AS
5、PDateAdd("s",Unixtimestamp,"01/01/197000:00:00")其他操作系统(如果Perl被安装在系统中)命令行状态：perl-e"printscalar(localtime(Unixtimestamp))"如何在不同编程语言中实现普通时间→Unix时间戳(Unixtimestamp)？Javalongepoch=newjava.text.SimpleDateFormat("dd/MM/yyyyHH:mm:ss").parse("01/01/197001:00:00");JavaScriptvarcommonTime=newDate(Date.UTC(year
6、,month-1,day,hour,minute,second))MySQLSELECTunix_timestamp(time)时间格式:YYYY-MM-DDHH:MM:SS或YYMMDD或YYYYMMDDPerl先useTime::Local然后my$time=timelocal($sec,$min,$hour,$day,$month,$year);PHPmktime(hour,minute,second,day,month,year)PostgreSQLSELECTextract(epochFROMdate('YYYY-MM-DDHH:MM:SS'));Python先importtime
7、然后int(time.mktime(time.strptime('YYYY-MM-DDHH:MM:SS','%Y-%m-%d%H:%M:%S')))RubyTime.local(year,month,day,hour,minute,second)SQLServerSELECTDATEDIFF(s,'1970-01-0100:00:00',time)Unix/Linuxdate+%s-d"Jan1,197000
