| 語言 | 體例 |
| JavaScript |
Math.round(new Date().getTime()/1000)
|
| 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 |
import time
|
| Ruby |
Time.now
|
| 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()) |
|
其他操作零星 (若是Perl被安置在零星中) |
perl -e "print time" |
| 語言 | 體例 |
| Java |
String date = new java.text.SimpleDateFormat("dd/MM/yyyy HH:妹妹:ss").format(new
java.util.Date( Unix timestamp * 1000))
|
| JavaScript |
var unixTimestamp = new Date( Unix timestamp * 1000)
|
| Linux | date -d @Unix timestamp |
| MySQL | from_unixtime(Unix timestamp) |
| Perl |
my $time = Unix timestamp
|
| PHP | date('r', Unix timestamp) |
| PostgreSQL |
SELECT TIMESTAMP WITH TIME ZONE 'epoch' + Unix timestamp) * INTERVAL '1
second';
|
| Python |
import 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") |
|
其他操作零星 (若是Perl被安置在零星中) |
perl -e "print scalar(localtime(Unix timestamp))"
|
| 語言 | 體例 |
| Java |
long epoch = new java.text.SimpleDateFormat("dd/MM/yyyy HH:妹妹:ss").parse("01/01/1970
01:00:00");
|
| JavaScript |
var co妹妹onTime = new Date(Date.UTC(year, month - 1,day, hour, minute, second))
|
| MySQL |
SELECT unix_timestamp(time)
|
| Perl |
use Time::Local
|
| PHP |
mktime(hour, minute, second, month, day, year)
|
| PostgreSQL | SELECT extract(epoch FROM date('YYYY-MM-DD HH:MM:SS')); |
| Python |
import time
|
| 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) |
