Unix Timestamp (Unix timestamp) conversion tool

Http://tool.chinaz.com/Tools/unixtime.aspx now the Unix timestamp (Unix timestamp) is1440732364Unix Timestamp (Unix timestamp) → Beijing Time →unix timestamp (Unix timestamp) How do I get the current UNIX timestamp (Unix timestamp) in different programming languages?

Java	Time
Javascript	Math.Round (New Date (). GetTime ()/1000) GetTime () The unit of return value is 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	Get UNIX timestamp: Time.now or Time.new Show 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 the system)	Command line status: PERL-E "Print Time"

How to implement UNIX timestamps in different programming languages ( 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	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 and 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 in the system)	Command line status: Perl-e "Print scalar (localtime (Unix timestamp))"

How to implement common time →unix timestamps in different programming languages ( 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	First 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 and 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)

Unix Timestamp (Unix timestamp) conversion tool