Unix timestamp functions in different languages ​​

The following are Unix timestamp functions for different languages:

Java time JavaScript Math.round(new Date().getTime()/1000) The unit of returnTime() returns 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 first import time and then time.time() Ruby gets Unix timestamp: Time.now or Time.new shows 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 system) the command line: perl -e & ldquo; print time & rdquo;

how Unix timestamp ( Unix timestamp
) & rarr in different programming languages; ordinary 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 on the system) Command line status: perl -e “print scalar(localtime(Unix timestamp
))”
How to implement normal time → Unix timestamp (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
) Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD Perl Use Time::Local then 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 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
, < u>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
)