iToolify Toolbox
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

Unix timestamp conversion tool

Unix timestamp conversion tool, which can convert Unix timestamps into standard format Beijing time, or convert standard format Beijing time into UNIX timestamp;

What is a Unix timestamp (Unix timestamp): Timestamp refers to the total number of seconds from January 1, 1970, 00: 00: 00 GMT (Beijing time, January 1, 1970, 08: 00: 00) to the present.

Usage of the PHP sample Unixtime：

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.itoolify.com）

1, different program languages or databases, get the current Unix timestamp (Unix timestamp) method:

PHP time()
Java time
JavaScript Math.round(new Date().getTime()/1000)
getTime() returns a numeric value in milliseconds
.NET / C# time = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000
MySQL SELECT unix_timestamp(now())
Perl time
PostgreSQL SELECT extract(time FROM now())
Python import time and then time.time()
Ruby Get Unix timestamp: Time.now or Time.new
Display 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())

2, different program languages or databases, the implementation of ordinary time-Unix timestamp (Unix timestamp):

PHP mktime(hour, minute, second, 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)
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);
PostgreSQL SELECT extract(datetime FROM date('YYYY-MM-DD HH:MM:SS'));
Python 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', 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 program languages or databases, Unix timestamp (Unix timestamp) is converted to normal time (year-month-day time: minute: second):

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 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]
PostgreSQL SELECT TIMESTAMP WITH TIME ZONE 'time' + Unix timestamp) * INTERVAL '1 second';
Python 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")
Your footprint:

iToolify ToolboxNavigation

Friend Links:iCMS