Unix Timestamp Converter, DateTime to Timestamp

Unix Timestamp, Unix Timestamp Conversion Tool

Current Timestamp

　Time

Unix Timestamp → Time

Unix Timestamp

Time

Time → Unix Timestamp

Beijing Time

Unix Timestamp

Introduction to Unix Timestamp Conversion Tool

The Unix Timestamp Conversion Tool allows for converting Unix timestamps to standard Beijing Time format and vice versa, converting standard time formats into Unix timestamps.

What is a Unix Timestamp: A Unix timestamp represents the total number of seconds between a particular date and the Unix Epoch, which is January 1, 1970, 00:00:00 GMT.

PHP Example Usage of Unix Time:

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

1. The method to obtain the current Unix timestamp in different program languages or databases:

PHP	time()
Java	time
JavaScript	Math.round(new Date().getTime()/1000) getTime() The unit of returned value 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, then, time.time()
Ruby	Get Unix timestamp: Time.now 或 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 program languages or databases, realize common time → 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) Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD
Perl	First, use Time::Local, then, my $time = timelocal($sec, $min, $hour, $day, $month, $year);
PostgreSQL	SELECT extract(datetime FROM date('YYYY-MM-DD HH:MM:SS'));
Python	First, import time, then, 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. How to convert a Unix timestamp to a normal time (year month day hour: minute: second) in different program 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	First, var unixTimestamp = new Date(Unix timestamp * 1000), then, commonTime = unixTimestamp.toLocaleString()
Linux	date -d @Unix timestamp
MySQL	from_unixtime(Unix timestamp)
Perl	First, my $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	First, 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")