時間戳轉換工具 - 在線Unix時間戳轉換

語言	代碼
Swift	NSDate().timeIntervalSince1970
Go	import ( "time" ) int64(time.Now().Unix())
Java	// pure java System.currentTimeMillis() / 1000 // joda java DateTime.now().getMillis() / 1000 // java >= 8 Instant.now().getEpochSecond()
C	#include // ... struct timeval tv; gettimeofday(&tv, NULL); // 秒： tv.tv_sec // 毫秒： tv.tv_sec * 1000LL + tv.tv_usec / 1000
JavaScript	Math.round(new Date() / 1000)
Objective-C	[[NSDate date] timeIntervalSince1970]
MySQL	SELECT unix_timestamp(now())
SQLite	SELECT strftime('%s', 'now')
PostgreSQL
SQL Server
Erlang	calendar:datetime_to_gregorian_seconds(calendar:universal_time())-719528243600.
PHP	// pure php time(); // carbon php use CarbonCarbon; Carbon::now()->timestamp;
Python	import time time.time() import arrow arrow.utcnow().timestamp
Ruby	Time.now.to_i
Groovy	(new Date().time / 1000).longValue()
Lua	os.time()
.NET/C#	DateTimeOffset.UtcNow.ToUnixTimeSeconds();
Dart	(new DateTime.now().millisecondsSinceEpoch / 1000).truncate()
Unix/Linux(Shell)	date +%s
Perl	time
VBScript/ASP
Other

語言	代碼
Swift	let date = Date(timeIntervalSince1970: timestamp)
Go
Java	String date = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(Unix timestamp * 1000))
C	#include #include void timestamp_to_datetime(time_t timestamp, struct tm datetime) { datetime = localtime(×tamp); // 使用localtime获取本地时间 // 如果需要UTC时间，使用gmtime // datetime = *gmtime(×tamp); }
JavaScript	var unixTimestamp = new Date(Unix timestamp * 1000) commonTime = unixTimestamp.toLocaleString()
Objective-C	NSDate *date = [NSDate dateWithTimeIntervalSince1970:timestamp];
MySQL	from_unixtime(Unix timestamp)
SQLite	SELECT datetime(1672444800, 'unixepoch');
PostgreSQL	SELECT TIMESTAMP WITH TIME ZONE 'epoch' + Unix timestamp) * INTERVAL '1 second';
SQL Server	DATEADD(s, Unix timestamp, '1970-01-01 00:00:00')
Erlang	UTCTime = calendar:system_time_to_datetime({seconds, UnixTimestampSec}).
PHP	date('r', Unix timestamp)
Python	import time time.gmtime(Unix timestamp)
Ruby	Time.at(Unix timestamp)
Groovy	LocalDateTime dateTime = LocalDateTime.now() DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss") String formatted = dateTime.format(formatter)
Lua
.NET/C#
Dart
Unix/Linux(Shell)	date -d @Unix timestamp
Perl	my $time = Unix timestamp my ($sec, $min, $hour, $day, $month, $year) = (localtime($time))[0,1,2,3,4,5,6]
VBScript/ASP	DateAdd("s", Unix timestamp, "01/01/1970 00:00:00")
Other	perl -e "print scalar(localtime(Unix timestamp))"

語言	代碼
Swift	let timestamp = Date().timeIntervalSince1970
Go
Java	long epoch = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").parse("01/01/1970 01:00:00");
C	#include #include time_t datetime_to_timestamp(int year, int month, int day, int hour, int minute, int second) { struct tm timeinfo = {0}; timeinfo.tm_year = year - 1900; // 年份从1900年开始 timeinfo.tm_mon = month - 1; // 月份从0开始 timeinfo.tm_mday = day; timeinfo.tm_hour = hour; timeinfo.tm_min = minute; timeinfo.tm_sec = second; timeinfo.tm_isdst = -1; // 让mktime自动判断夏令时 return mktime(&timeinfo); }
JavaScript	var commonTime = new Date(Date.UTC(year, month - 1, day, hour, minute, second))
Objective-C	NSDate *dateFromMillis = [NSDate dateWithTimeIntervalSince1970:timestampInSeconds];
MySQL	SELECT unix_timestamp(time)
SQLite	SELECT datetime(1672444800000 / 1000, 'unixepoch');
PostgreSQL	SELECT extract(epoch FROM date('YYYY-MM-DD HH:MM:SS'));
SQL Server	SELECT DATEDIFF(s, '1970-01-01 00:00:00', time)
Erlang	UnixTimestampSec = calendar:datetime_to_system_time(SpecificDateTime) div 1000.
PHP	mktime(hour, minute, second, month, day, year)
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)
Groovy
Lua
.NET/C#
Dart
Unix/Linux(Shell)	date +%s -d"Jan 1, 1970 00:00:01"
Perl	use Time::Local my $time = timelocal($sec, $min, $hour, $day, $month, $year);
VBScript/ASP	DateDiff("s", "01/01/1970 00:00:00", time)
Other

Unix時間戳轉換工具