وبر تالاب ماسترو.کم
Unix timestamp, Unix timestamp conversion tool
Current timestamp
　Beijing time

Unix timestamp (Unix timestamp) → Beijing time

Unix timestamp
Beijing time

Beijing time → Unix timestamp (Unix timestamp)

Beijing time
Unix timestamp

Introduction to the Unix timestamp conversion tool

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)

1. How to obtain the current Unix timestamp (Unix timestamp) in different programming languages or databases:

PHP Time ()
Java تائم
JavaScript Math.round (new Date ().getTime ()/1000)
getTime () میں میلزائیڈز میں ایک مقصد بر آمد کرتا ہے
.NET/سی# تائم = (DateTime.Now. ToUniversalTime (). تیکس - 621355968000000000)/10000000
MySQL SELECT unix_timestamp (ابلیتیو دی سگوند ())
Perl تائم
PostgreSQL SELECT extract (time FROM ابلیتیو دی سگوند ())
Python پہلے وقت درآمد کریں اور بعد میں تائم نال.توآی ()
Ruby گٹ اونیکس تمپستیس: تائم نال.توآی یا تائم نال نیو
شو اونیکس تمپستیس: تائم نال.توآی
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", ابلیتیو دی سگوند ()

2. In different programming languages or databases, implement ordinary time → Unix timestamp (Unix timestamp):

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
Perl ابتدا از Time :: Local استفاده کنید سپس my $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)

3. In different programming languages or databases, Unix timestamp (Unix timestamp) is converted to normal time (year-month-day time: minutes: seconds):

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)
Perl ابتدا my $time = Unix timestamp سپس my ($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 second ';
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)
قدمهای شما:

آن لائن ٹول باکس نیویگیشن