时间戳与日期之间的相互转换整理

Perl语言：

#获取当前时间的时间戳
my $time = time;
print $time.'\n';

#时间戳 ——> 日期
use POSIX qw(strftime);
my $time = strftime("%Y-%m-%d %H:%M:%S\n",  localtime('1447299889'));
print $time.'\n';

#日期 -->时间戳
use Time::Local;
my $year = 2015;
my $mon = 10;
my $mday = 19;
my $hours = 20;
my $min = 30;
my $sec = 0;
my $time = timelocal($sec,$min,$hours,$mday,$mon,$year); 
print  $time."\n";

PHP语言：

#获取当前时间的时间戳
$time = time();
print $time.'\n';

#时间戳 ——> 日期
$time = date('Y-m-d H:i:s',time());
print $time.'\n';

#日期 -->时间戳
$time = strtotime('2015-10-11');
print  $time."\n";

javascript:

//获取现在时间戳
var time = Math.round(new Date().getTime()/1000)
alert(time);

//时间戳-->日期
var timestamp = new Date(1447299889*1000);
var time = timestamp.toLocaleString();
alert(time);

//日期 --> 时间戳
var time = new Date(Date.UTC(year,month-1,day,hour,minute,second));
alert(time);

MySQL:

//获取现在时间戳
SELECT unix_timestamp(now())

//时间戳 --> 日期
select  from_unixtime('1447299889')

//日期 --> 时间戳
select unix_timestamp('2015-10-10')

收藏更多的地址：
http://blog.csdn.net/morley_wang/article/details/7999361