Unix Timestamp Conversion Tool Seconds Since January 1, 1970 (UTC)
Current Time:
Seconds
Change Format
Seconds
Seconds
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:
| 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 | import time + time.time() |
| Ruby | Time.now、Time.new、Time.now.to_i |
| Go | import time + int32(time.Now().Unix()) |
| 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()) |
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() |
| 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] |
| PHP | date('r', Unix timestamp) |
| PostgreSQL | SELECT TIMESTAMP WITH TIME ZONE 'epoch' + Unix timestamp) * INTERVAL '1 second'; |
| Python | import time + 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") |
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)) |
| MySQL | SELECT unix_timestamp(time) |
| Perl | use Time::Local + my $time = timelocal($sec, $min, $hour, $day, $month, $year); |
| PHP | mktime(hour, minute, second, month, day, year) |
| PostgreSQL | SELECT 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'))) |
| 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) |
Information Area: (All features on this website are free and are maintained through advertisements and sponsors)
X
Business Collaboration: