KivTools
Unix Timestamp, Unix Timestamp Conversion Tool
Current time stamp
　Beijing Time

Unix Timestamp

Unix Timestamp
Beijing Time

Beijing Time Unix Timestamp

Beijing Time
Unix Timestamp

Introduction to the Unix Timetamp Conversion Tool

The Unix Timestamp conversion tool allows for the conversion of Unix Timestamps to Beijing time in the standard format or to UNIX timetamps in the standard format;

(a) What is a UNIX timestamp: a time stamp is the total number of seconds from 0100 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 01/01 1970 Beijing time) GMT to the present.

PHP for example Unixtime：

Other Organiser$time = time(); Convert to Beijing time:$datetime = date('Y-m-d H:i:s',$time); Convert to time stamp:$unixtime = strtotime($datetime);（www.pcjson.com）

1. The method of accessing the current Unix timestamp in different program languages or databases:

PHP time()
Java time
JavaScript Math.round(new Date().getTime()/1000)
getTime() returns 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 First Import time and then time.time()
Ruby Get UNIX Timestamp: Time.now or Time.new
Show Unix time stamp: 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())

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: YYY-MM-DD HH:MM:SS or YYMMDD or YYYMMDD
Perl First, use Time: Local and then my $time = timelocal ($sec, $min, $hour, $day, $month, $year);
PostgreSQL SELECT extract(datetime FROM date('YYYY-MM-DD HH:MM:SS'));
Python First Import time and then int (time.mktime (`YYYY-MM-DD HH:SM:SS', '%Y-%m-%d:%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 is converted to normal time (year-month-day: 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 First var unixTimestamp = new Date (Unix timestamp * 1000) and then commonTime = unixTimestring()
Linux date -d @Unix timestamp
MySQL from_unixtime(Unix timestamp)
Perl My $time = Unix timestamp and my ($sec, $min, $hour, $day, $month, $year) = (localtime) [0,1,2,3,4,5,5]
PostgreSQL SELECT TIMESTAMP WITH TIME ZONE 'time' + Unix timestamp) * INTERVAL '1 second';
Python First Import time and then time.
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")
Recent tools:

KivTools Navigator