Instrumente online
Unix timestamp, Unix timestamp instrument de conversie
Timestamp curent
　 Ora Beijing

Timestamp Unix(Unix timestamp) → Ora Beijing

Timestamp Unix
Ora Beijing

Ora Beijing → Timestamp Unix(Unix timestamp)

Ora Beijing
Timestamp Unix

1, diferite limbaje de programare sau baze de date, obțineți timestampurile Unix actuale(Unix timestamp) metodă:

PHP time()
Java time
JavaScript Math.round(new Date().getTime()/1000)
getTime() valoare de retur în milisecunde
.NET / C# time = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000
MySQL SELECT unix_timestamp(now())
Perl time
PostgreSQL SELECT extract(time FROM now())
Python importați mai întâi time și apoi time.time()
Ruby Obțineți timestamp Unix: Time.now sau Time.new
Afișați timestamp-ul 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())

2, diferite limbaje de programare sau baze de date, implementarea timpului comun → Timestamps Unix(Unix timestamp)：

PHP mktime(hour, minute, second, day, month, year)
Java long datetime = 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)
Formatul timpului: YYYY-MM-DD HH:MM:SS sau YYMMDD sau YYYYMMDD
Perl utilizați mai întâi Time::Local apoi my$time = timelocal($sec, $min, $hour, $day, $month, $year);
PostgreSQL SELECT extract(datetime FROM date('YYYY-MM-DD HH:MM:SS'));
Python importați time apoi 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', datetime)
Unix / Linux date +%s -d"Jan 1, 1970 00:00:01"
VBScript / ASP DateDiff("s", "01/01/1970 00:00:00", datetime)

3. Timestamps Unix în diferite limbaje de programare sau baze de date(Unix timestamp) Timestampurile Unix în diferite limbaje de programare sau baze de date sunt convertite în timp normal (an lună zi oră:minut:secundă):

PHP date('r', Unix timestamp)
Java String datetime = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(Unix timestamp * 1000))
JavaScript first var unixTimestamp = new Date(Unix timestamp * 1000) apoi commonTime = unixTimestamp.toLocaleString()
Linux date -d @Unix timestamp
MySQL from_unixtime(Unix timestamp)
Perl primul meu$ time = Unix timestamp then my($sec, $min, $hour, $day, $month, $year) = (localtime($time))[0,1,2,3,4,5,6]
PostgreSQL SELECT TIMESTAMP WITH TIME ZONE 'time' + Unix timestamp) * INTERVAL '1 second';
Python import time then 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")
Accesul la înregistrări: