Unix timestamp, Unix timestamp conversion tool
current timestamp
Beijing time

Unix timestamp → Beijing time

Unix timestamp
Beijing time

Beijing time → Unix timestamp (Unix timestamp)

Beijing time
Unix timestamp

Introduction to Unix timestamp conversion tool

Unix timestamp conversion tool can convert Unix timestamps into standard format Beijing time, and can also convert standard format Beijing time into UNIX timestamps;

What is a Unix timestamp (Unix timestamp): A timestamp refers to the time from January 1, 1970, 00:00:00 Greenwich Time (08:00:00, January 1, 1970, Beijing time) to the present Total seconds.

PHP example Unixtime usage

Get the current timestamp:$time = time();Convert to Beijing time:$datetime = date('Y-m-d H:i:s',$time);Convert to timestamp:$unixtime = strtotime($datetime);(www.pcjson.com)

1. Methods to obtain the current Unix timestamp (Unix timestamp) in different programming languages ​​or databases:

PHP time()
Java time
JavaScript Math.round(new Date().getTime()/1000)
The unit of the value returned by getTime() is milliseconds
.NET / C# time = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000
MySQL SELECT unix_timestamp(now())
Perl time
PostgreSQL SELECT extract(time FROM now())
Python First import time and then time.time()
Ruby Get Unix timestamp: Time.now or Time.new
Display Unix timestamp: 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. In different programming languages ​​or databases, implement ordinary time → Unix timestamp (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)
Perl 先 use Time::Local 然后 my $time = timelocal($sec, $min, $hour, $day, $month, $year);
PostgreSQL SELECT extract(datetime 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', datetime)
Unix / Linux date +%s -d"Jan 1, 1970 00:00:01"
VBScript / ASP DateDiff("s", "01/01/1970 00:00:00", datetime)

3. Convert Unix timestamp to ordinary time (year-month-day hour:minute:second) in different programming languages ​​or databases:

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 先 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]
PostgreSQL SELECT TIMESTAMP WITH TIME ZONE 'time' + Unix timestamp) * INTERVAL '1 second';
Python First import time and 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")
Language: English | 中文 | Русский | Español | Português | हिन्दी | தமிழ் | Deutsch | Français | عربي | 日本語 | 한국어
Your track:
Advertising area 1