阿里云新人推荐(460*60)alyxrtj460

UNIX timestamp conversion tool

currentUNIX timestamp(Unix timestamp)是      Start  Stop  Refresh 

UNIX timestamp(Unix timestamp) → Beijing time
UNIX timestamp(Unix timestamp) Beijing time

Beijing time → UNIX timestamp(Unix timestamp)
Beijing time UNIX timestamp

Beijing time → UNIX timestamp(Unix timestamp)
Beijing time Year month day hour minute second
UNIX timestamp
How to obtain the current UNIX timestamp in different programming languages?
Java time
JavaScript Math.round(new Date().getTime()/1000)
getTime()The returned value is in milliseconds
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 before import time then time.time()
Ruby 获取UNIX timestamp:Time.now or Time.new
显示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 on the system})
Command line status:perl -e "print time"

How to implement in different programming languagesUNIX timestamp(Unix timestamp) → Normal time?
Java String date = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(Unix timestamp * 1000))
JavaScript before var unixTimestamp = new Date(Unix timestamp * 1000) then commonTime = unixTimestamp.toLocaleString()
Linux date -d @Unix timestamp
MySQL from_unixtime(Unix timestamp)
Perl before 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 before 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 on the system})
命令行状态:perl -e "print scalar(localtime(Unix timestamp))"

How to implement common time in different programming languages → UNIX timestamp(Unix timestamp)?
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)
Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD
Perl before 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 before 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)

Tool introduction

What is UNIX timestamp: Unix timestamp, or UNIX time and POSIX time, is a time representation, defined as the total number of seconds from 00:00:00 on January 1, 1970 Greenwich mean time to the present. UNIX timestamp is not only used in UNIX systems and UNIX like systems, but also widely used in many other operating systems



阿里云老客户续费优惠

For infringement, consultation or customized technical services, please click QQClick here to send me a messageContact me, thank you!

Powered by Star Station tools Certificate Code © 2010-2022 Xmspace.net Corporation