如何在不同编程语言中实现普通时间转换成Unix时间戳(Unix timestamp)?

Java

long epoch = 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

use Time::Local

然后

my $time = timelocal($sec, $min, $hour, $day, $month, $year);

PHP

mktime(hour, minute, second, month, day, year)

PostgreSQL

SELECT EXTRACT(epoch FROM DATE('YYYY-MM-DD HH:MM:SS'));

Python

import time

然后

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', TIME)

Unix / Linux

date +%s -d"Jan 1, 1970 00:00:01"

VBScript / ASP

DateDiff("s", "01/01/1970 00:00:00", time)

还没有评论,快来抢沙发!

发表评论

  • 😉
  • 😐
  • 😡
  • 😈
  • 🙂
  • 😯
  • 🙁
  • 🙄
  • 😛
  • 😳
  • 😮
  • emoji-mrgree
  • 😆
  • 💡
  • 😀
  • 👿
  • 😥
  • 😎
  • ➡
  • 😕
  • ❓
  • ❗
  • 69 queries in 0.400 seconds