å¦ä½å¨ä¸åç¼ç¨è¯è¨ä¸è·åç°å¨çUnixæ¶é´æ³(Unix timestamp)ï¼
å
ä¸ä»£ç è¿è¡javaæ¶é´è½¬æ¢æunix timestamp
[html] view plaincopy
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
/**
* @author kongqz
[email protected] * @version å建æ¶é´ï¼2013-2-19 ä¸å10:21:47
*/
public class TestUnixTime {
public static void main(String[] args) throws ParseException{
DateFormat df=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//1361325960
long epoch = df.parse("2013-02-20 10:06:00").getTime();
System.out.println("should be 1361325960 ï¼"+epoch);
Date d=new Date();
String t=df.format(d);
epoch=df.parse(t).getTime()/1000;
System.out.println("t is ï¼"+t+",unix stamp is "+epoch);
}
}
Java time
JavaScript Math.round(new Date().getTime()/1000)
getTime()è¿åæ°å¼çåä½æ¯æ¯«ç§
Microsoft .NET / C# epoch = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000
MySQL SELECT unix_timestamp(now())
Perl time
PHP time()
PostgreSQL SELECT extract(epoch FROM now())
Python å
import time ç¶å time.time()
Ruby è·åUnixæ¶é´æ³ï¼Time.now æ Time.new
æ¾ç¤º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", Now())
å
¶ä»æä½ç³»ç»
(å¦æPerl被å®è£
å¨ç³»ç»ä¸) å½ä»¤è¡ç¶æï¼perl -e "print time"
å¦ä½å¨ä¸åç¼ç¨è¯è¨ä¸å®ç°Unixæ¶é´æ³(Unix timestamp) â æ®éæ¶é´ï¼
Java String date = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(Unix timestamp * 1000)).getTime();
JavaScript å
var unixTimestamp = new Date(Unix timestamp * 1000)ç¶å commonTime = unixTimestamp.toLocaleString()
Linux date -d @Unix timestamp
MySQL from_unixtime(Unix timestamp)
Perl å
my $time = Unix timestamp ç¶å my ($sec, $min, $hour, $day, $month, $year) = (localtime($time))[0,1,2,3,4,5,6]
PHP date('r', Unix timestamp)
PostgreSQL SELECT TIMESTAMP WITH TIME ZONE 'epoch' + Unix timestamp) * INTERVAL '1 second';
Python å
import time ç¶å 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")
å
¶ä»æä½ç³»ç»
(å¦æPerl被å®è£
å¨ç³»ç»ä¸) å½ä»¤è¡ç¶æï¼perl -e "print scalar(localtime(Unix timestamp))"
å¦ä½å¨ä¸åç¼ç¨è¯è¨ä¸å®ç°æ®éæ¶é´ â Unixæ¶é´æ³(Unix timestamp)ï¼
Java long epoch = 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)
æ¶é´æ ¼å¼: YYYY-MM-DD HH:MM:SS æ YYMMDD æ YYYYMMDD
Perl å
use Time::Local ç¶å my $time = timelocal($sec, $min, $hour, $day, $month, $year);
PHP mktime(hour, minute, second, day,month,year)
PostgreSQL SELECT 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:%S')))
Ruby Time.local(year, month, day, hour,minute,second)
SQL Server SELECT DATEDIFF(s, '1970-01-01 00:00:00', time)
Unix / Linux date +%s -d"Jan 1, 1970 00:00:01"
VBScript / ASP DateDiff("s", "01/01/1970 00:00:00", time)