Unix Timestamp Conversion Tool Seconds Since January 1, 1970 (UTC)

Current Time:
Change Format
(adsbygoogle = window.adsbygoogle || []).push({});

What is a Unix Timestamp?

A time representation method that counts in seconds starting from January 1, 1970, in Greenwich Mean Time.

A Unix Timestamp (Unix timestamp), also known as Unix time or POSIX time, is commonly used to record the time of events, calculate time intervals, and track and sort time in various applications. Since Unix Timestamps are in seconds, they are consistent worldwide and are not affected by time zones or geographical locations. For example, if you need to record the time of events in both the United States and China, you can ensure consistency by using Unix Timestamps. For more detailed information, you can refer to Narrative Knowledge Base - What is Unix time?

Methods to Get Current Unix Timestamp in Different Languages:

JavaScriptMath.round(new Date().getTime()/1000)
Microsoft .NET / C# epoch = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000
MySQLSELECT unix_timestamp(now())
PostgreSQLSELECT extract(epoch FROM now())
Pythonimport time + time.time()
Go import time + int32(time.Now().Unix())
SQL ServerSELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())
Unix / Linuxdate +%s
VBScript / ASPDateDiff("s", "01/01/1970 00:00:00", Now())

Methods to Convert Unix Timestamp to Regular Time in Different Languages:

Java String date = 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()
Linuxdate -d @Unix timestamp
MySQLfrom_unixtime(Unix timestamp)
Perl my $time = Unix timestamp + my ($sec, $min, $hour, $day, $month, $year) = (localtime($time))[0,1,2,3,4,5,6]
PHPdate('r', Unix timestamp)
PostgreSQL SELECT TIMESTAMP WITH TIME ZONE 'epoch' + Unix timestamp) * INTERVAL '1 second';
Pythonimport time + time.gmtime(Unix timestamp)
RubyTime.at(Unix timestamp)
SQL ServerDATEADD(s, Unix timestamp, '1970-01-01 00:00:00')
VBScript / ASPDateAdd("s", Unix timestamp, "01/01/1970 00:00:00")

Methods to Convert Regular Time to Unix Timestamp in Different 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))
MySQLSELECT unix_timestamp(time)
Perl use Time::Local + my $time = timelocal($sec, $min, $hour, $day, $month, $year);
PHPmktime(hour, minute, second, month, day, year)
PostgreSQLSELECT extract(epoch 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')))
RubyTime.local(year, month, day, hour, minute, second)
SQL ServerSELECT DATEDIFF(s, '1970-01-01 00:00:00', time)
Unix / Linuxdate +%s -d"Jan 1, 1970 00:00:01"
VBScript / ASPDateDiff("s", "01/01/1970 00:00:00", time)

Information Area: (All features on this website are free and are maintained through advertisements and sponsors)

Business Collaboration:
(adsbygoogle = window.adsbygoogle || []).push({});
(adsbygoogle = window.adsbygoogle || []).push({});