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

Java

String date = 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]

PHP

date('r', Unix timestamp)

PostgreSQL

SELECT TIMESTAMP WITH TIME ZONE 'epoch' + Unix TIMESTAMP) * INTERVAL '1 second';

Python

import time

然后

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")

其他操作系统
(如果Perl被安装在系统中) 命令行状态:

perl -e "print scalar(localtime(Unix timestamp))"

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

发表评论

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