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

Timestamp Unix(Unix timestamp) → Ora Beijing

Timestamp Unix
Ora Beijing

Ora Beijing → Timestamp Unix(Unix timestamp)

Ora Beijing
Unix Timestamp

1, diferite limbaje de programare sau baze de date, pentru a obține timestamp-ul Unix curent(Unix timestamp) în diferite limbaje de programare sau baze de date:

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