Unix timestamp (Unix timestamp) → Beijing time
Beijing time → Unix timestamp (Unix timestamp)
Unix timestamp conversion tool, which can convert Unix timestamp to Beijing time in standard format, and can also convert Beijing time in standard format to UNIX timestamp;
What is a Unix timestamp (Unix timestamp): The timestamp refers to the total number of seconds from the Greenwich Mean Time on January 1, 1970 at 00:00:00 (Beijing time on January 1, 1970 at 08:00:00) to the present.
PHP Example Usage of UnixtimeWhat is it?
Get the current timestamp:$time = time (); Convert to Beijing time:$datetime = date ('Y-m-d H: i: s', $time); Convert to timestamp:$Unixtime = strtotime ($datetime);(www.webmastertoolbag. com)
| PHP | Time () |
| Java | Time |
| JavaScript | Math.round (new Date ().getTime ()/1000) getTime () returns a value in milliseconds |
| .NET/C# | Time = (DateTime.Now. ToUniversalTime (). Ticks - 621355968000000000)/10000000 |
| MySQL | SELECT unix_timestamp (now ()) |
| पर्ल | Time |
| PostgreSQL | SELECT extract (time 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", अभी () |
| PHP | MKTime (hours, minutes, seconds, day, month, year) |
| Java | Long datetime = 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) तारीख फॉर्मेट: YYYY-MM-DD HH: MM: SS या YYMMDD या YYYYMMDD |
| पर्ल | पहले Time :: Local इस्तेमाल करें फिर मेरा $time = timelocal ($sec, $min, $hour, $day, $month, $year); |
| PostgreSQL | SELECT extract (datetime FROM date ('YYYY-MM-DD HH: MM: SS')); |
| Python | पहले आयात वक्त फिर 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', datetime) |
| Unix/Linux | Date +% s -d "Jan 1, 1970 00:00:01" |
| VBScript/ASP | DateDiff ("s", "01/01/1970 00:00:00", datetime) |
| PHP | Date ('r', Unix timestamp) |
| Java | String datetime = 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) |
| पर्ल | पहले मेरा $time = Unix timestamp फिर मेरा ($sec, $min, $hour, $day, $month, $year) = (localtime ($time)) [0, 1, 2, 3, 4, 5, 6] |
| PostgreSQL | SELECT TIMESTAMP WITH TIME ZONE'time '+ Unix timestamp) * INTERVAL' 1 दूसरा '; |
| Python | पहले आयात वक्त और फिर 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) |
