Tabler XTool

时间戳 转换

About

Xtool is a versatile tool designed to convert Unix timestamps into human-readable time and vice versa. It also includes features such as timezone conversion, batch processing, and timestamp comparison. With Xtool, users can easily manage and track their data in a convenient manner. This user-friendly tool makes it easy to work with timestamps for everyday tasks.

What is the unix time stamp?

The unix time stamp is a way to track time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970 at UTC. Therefore, the unix time stamp is merely the number of seconds between a particular date and the Unix Epoch. It should also be pointed out (thanks to the comments from visitors to this site) that this point in time technically does not change no matter where you are located on the globe. This is very useful to computer systems for tracking and sorting dated information in dynamic and distributed applications both online and client side.

Human Readable Time Seconds
1 Hour 3600 Seconds
1 Day 86400 Seconds
1 Week 604800 Seconds
1 Month (30.44 days) 2629743 Seconds
1 Year (365.24 days) 31556926 Seconds

What happens on January 19, 2038?

On this date the Unix Time Stamp will cease to work due to a 32-bit overflow. Before this moment millions of applications will need to either adopt a new convention for time stamps or be migrated to 64-bit systems which will buy the time stamp a "bit" more time.

如何在不同编程语言中获取现在的Unix时间戳(Unix timestamp)？

Java time
JavaScript Math.round(new Date().getTime()/1000)
getTime()
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 Get Unix Timestamp: Time.now (or Time.new)
Show Unix Timestamp: 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())
Other OS
(If Perl was installed) 		perl -e "print time"

如何在不同编程语言中实现Unix时间戳(Unix timestamp) → 普通时间？

Java String date = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(${UnixTimestamp} * 1000))
JavaScript let unixTimestamp = new Date(${UnixTimestamp} * 1000)
const humanTime = unixTimestamp.toLocaleString()
Linux date -d @${UnixTimestamp}
MySQL from_unixtime(${UnixTimestamp})
Perl my $time = ${UnixTimestamp}
my ($sec, $min, $hour, $day, $month, $year) = (localtime($time))[0,1,2,3,4,5,6]
PHP date('r', ${UnixTimestamp})
PostgreSQL SELECT TIMESTAMP WITH TIME ZONE 'epoch' + ${UnixTimestamp}) * INTERVAL '1 second';
Python import time
time.gmtime(${UnixTimestamp})
Ruby Time.at(${UnixTimestamp})
SQL Server DATEADD(s, ${UnixTimestamp}, '1970-01-01 00:00:00')
VBScript / ASP DateAdd("s", ${UnixTimestamp}, "01/01/1970 00:00:00")
Other OS
(If Perl was installed) 		perl -e "print scalar(localtime(${UnixTimestamp}))"
## 如何在不同编程语言中实现普通时间 → Unix时间戳(Unix timestamp)？
Java long epoch = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").parse("01/01/1970 01:00:00");
JavaScript let commonTime = new Date(Date.UTC(year, month - 1, day, hour, minute, second))
MySQL SELECT unix_timestamp(time)
Date Format: YYYY-MM-DD HH:MM:SS or YYMMDDor YYYYMMDD
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)