Current Unix timestamp 1480228974
Epoch timestamp
GMT: 1970/1/1 8:0:0
GMT Year Month Day ::
Epoch timestamp:
Overview

The UNIX timestamp conversion tool can convert UNIX timestamps into standard format GMT, and can also convert standard format GMT into UNIX timestamp.

About Unix timestamp

The timestamp refers to the total number of seconds since 00:00:00, January 1, 1970, Greenwich Mean Time (08:00, 01:01, 1970, Beijing Time) to the present.


How to get the current Unix timestamp in different programming languages?

Java time
JavaScript Math.round(new Date().getTime()/1000)
Microsoft .NET / C# epoch = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000
MySQL SELECT unix_timestamp(now())
Perl time
PHP time()
PostgreSQL SELECT extract(epoch FROM now())
Python First import time, then use time.time()
Ruby Get Unix timestamp: Time.now or Time.new
Show 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())
Other operating systems
(If Perl is installed in the system)
Command line:perl -e "print time"

How to implement Unix timestamp in different programming languages, namely Unix timestamp to human readable time?

Java String date = 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]
PHP date('r', Unix timestamp)
PostgreSQL SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 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")
Other operating systems
(If Perl is installed in the system)
Command line: perl -e "print scalar(localtime(Unix timestamp))"

How to convert ordinary time to Unix timestamp in different programming languages?

Java long epoch = 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 First use Time::Local, then my $time = timelocal($sec, $min, $hour, $day, $month, $year);
PHP mktime(hour, minute, second, day, month, year)
PostgreSQL SELECT extract(epoch 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', time)
Unix / Linux date +%s -d"Jan 1, 1970 00:00:01"
VBScript / ASP DateDiff("s", "01/01/1970 00:00:00", time)