6 lines
9.0 KiB
HTML
6 lines
9.0 KiB
HTML
<!DOCTYPE html><html lang="zh-CN"><head><meta charset="utf-8" /><meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no" /><title>{$my.Think.config.web.unixtime.title}</title><meta name="applicable-device" content="pc,mobile" /><meta http-equiv="Cache-Control" content="no-transform" /><meta http-equiv="Cache-Control" content="no-siteapp" /><meta name="keywords" content="{$my.Think.config.web.unixtime.keywords}" /><meta name="description" content="{$my.Think.config.web.unixtime.description}" /><meta name="renderer" content="webkit" /><meta name="apple-mobile-web-app-capable" content="yes" /><link rel="icon" href="/favicon.ico" mce_href="/favicon.ico" type="image/x-icon" /><link href="/static/style/bootstrap.min.css" rel="stylesheet" type="text/css" /><link href="/static/style/tool.css" rel="stylesheet" type="text/css" /><!--[if lt IE 9]><script src="http://apps.bdimg.com/libs/html5shiv/3.7/html5shiv.min.js"></script><script src="http://apps.bdimg.com/libs/respond.js/1.4.2/respond.min.js"></script><![endif]-->{:$my.Think.config.web.header}</head><body>{include file="header" /}
|
||
<div class="container"><div class="row"><div class="col-md-12 col10main"><div class="accordion" id="accordion2"><div class="accordion-group"><!-- <div><a href="https://www.aliyun.com/minisite/goods?userCode=eaborev5" target="_blank" rel="nofollow"><img src="http://zxgj.16400.cn/static/images/ali.jpg"></a></div> -->
|
||
<ul class="nav nav-tabs hbflag"><li role="presentation"><a href="/enlower/">英文字母大小写转换</a></li><li role="presentation"><a href="/rmbdaxie/">人民币大写转换工具</a></li><li role="presentation"><a href="/random/">随机数生成器</a></li><li role="presentation" class="active"><a href="/unixtime/"> Unix时间戳在线转换</a></li><li role="presentation"><a href="/hexconvert/">常用进制转换工具</a></li></ul><div class="row"><div class="col-lg-12"><div class="panel panel-default"><div class="panel-heading">Unix时间戳, Unix时间戳转换工具</div><div class="panel-body"><div class="row"><div class="col-lg-3"><div class="form-group input-group"><span class="input-group-addon">当前时间戳</span><input type="text" class="form-control now-time" value=""></div></div><div class="col-lg-4"><div class="form-group input-group"><span class="input-group-addon"> 北京时间</span><input type="text" class="form-control bj-now-time" id="time1-bj" value=""></div></div><div class="col-lg-3"><div class="form-group input-group"><button class="btn btn-default" onclick="startTimer();return false;">开始</button><button class="btn btn-default" onclick="stopTimer();return false;">停止</button><button class="btn btn-default" onclick="currentTime();return false;">刷新</button> </div></div></div><div class="row"><div class="col-lg-12"><p>Unix时间戳(Unix timestamp) → 北京时间</p></div></div><div class="row"><div class="col-lg-3"><div class="form-group input-group"><span class="input-group-addon">Unix时间戳</span><input type="text" class="form-control time1" value=""></div></div><div class="col-lg-2"><button type="button" class="btn btn-outline btn-success time2date">转换 → 日期</button></div><div class="col-lg-3"><div class="form-group input-group"><span class="input-group-addon">北京时间</span><input type="text" class="form-control time1-bj" value=""></div></div></div><div class="row"><div class="col-lg-12"><p>北京时间 → Unix时间戳(Unix timestamp)</p></div></div><div class="row"><div class="col-lg-3"><div class="form-group input-group"><span class="input-group-addon">北京时间</span><input type="text" class="form-control time2-bj" value=""></div></div><div class="col-lg-2"><button type="button" class="btn btn-outline btn-success date2time">转换 → 时间戳</button></div><div class="col-lg-3"><div class="form-group input-group"><span class="input-group-addon">Unix时间戳</span><input type="text" class="form-control time2" value=""></div></div></div></div></div></div></div></div><div class="alert alert alert-success alert-dismissible"><h4>Unix时间戳转换工具介绍</h4><p>Unix时间戳转换工具，可以将Unix时间戳转换成标准格式的北京时间，也可以将标准格式的北京时间转换为 UNIX 时间戳；</p><p>什么是Unix时间戳(Unix timestamp)：时间戳是指格林威治时间1970年01月01日00时00分00秒(北京时间1970年01月01日08时00分00秒)起至现在的总秒数。</p><p><strong>PHP示例Unixtime的用法</strong>：</p><p>获取当前时间戳：<em class='code_label'>$time = time();</em> 转换为北京时间：<em class='code_label'>$datetime = date('Y-m-d H:i:s',$time);</em> 转换为时间戳：<em class='code_label'>$unixtime = strtotime($datetime);</em>（www.<font>pcjson</font>.com）</p></div><div class="panel panel-default"><h4>1、不同程序语言或数据库中，获取现在的Unix时间戳(Unix timestamp)的方法：</h4><table class="table table-hover table-bordered table-striped"> <tbody> <tr> <td>PHP</td> <td>time()</td></tr><tr> <td width="200">Java</td> <td>time</td></tr><tr> <td>JavaScript</td> <td>Math.round(new Date().getTime()/1000)<br>getTime()返回数值的单位是毫秒</td></tr><tr> <td>.NET / C#</td> <td>time = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000</td></tr><tr> <td>MySQL</td> <td>SELECT unix_timestamp(now())</td></tr><tr> <td>Perl</td> <td>time</td></tr><tr> <td>PostgreSQL</td> <td>SELECT extract(time FROM now())</td></tr><tr> <td>Python</td> <td>先 import time 然后 time.time()</td></tr><tr> <td>Ruby</td> <td>获取Unix时间戳：Time.now 或 Time.new<br>显示Unix时间戳：Time.now.to_i</td></tr><tr> <td>SQL Server</td> <td>SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE())</td></tr><tr> <td>Unix / Linux</td> <td>date +%s</td></tr><tr> <td>VBScript / ASP</td> <td>DateDiff("s", "01/01/1970 00:00:00", Now())</td></tr> </tbody></table> </div><div class="panel panel-default"><h4>2、不同程序语言或数据库中，实现普通时间 → Unix时间戳(Unix timestamp)：</h4><table class="table table-hover table-bordered table-striped"> <tbody> <tr> <td>PHP</td> <td>mktime(hour, minute, second, day, month, year)</td></tr><tr> <td width="200">Java</td> <td>long datetime = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").parse("01/01/1970 01:00:00");</td></tr><tr> <td>JavaScript</td> <td>var commonTime = new Date(Date.UTC(year, month - 1, day, hour, minute, second))</td></tr><tr> <td>MySQL</td> <td>SELECT unix_timestamp(time)<br>时间格式: YYYY-MM-DD HH:MM:SS 或 YYMMDD 或 YYYYMMDD</td></tr><tr> <td>Perl</td> <td>先 use Time::Local 然后 my $time = timelocal($sec, $min, $hour, $day, $month, $year);</td></tr><tr> <td>PostgreSQL</td> <td>SELECT extract(datetime FROM date('YYYY-MM-DD HH:MM:SS'));</td></tr><tr> <td>Python</td> <td>先 import time 然后 int(time.mktime(time.strptime('YYYY-MM-DD HH:MM:SS', '%Y-%m-%d %H:%M:%S')))</td></tr><tr> <td>Ruby</td> <td>Time.local(year, month, day, hour, minute, second)</td></tr><tr> <td>SQL Server</td> <td>SELECT DATEDIFF(s, '1970-01-01 00:00:00', datetime)</td></tr><tr> <td>Unix / Linux</td> <td>date +%s -d"Jan 1, 1970 00:00:01"</td></tr><tr> <td>VBScript / ASP</td> <td>DateDiff("s", "01/01/1970 00:00:00", datetime)</td></tr> </tbody></table></div><div class="panel panel-default"><h4>3、不同程序语言或数据库中，Unix时间戳(Unix timestamp) 转为 普通时间（年-月-日 时:分:秒）：</h4><table class="table table-hover table-bordered table-striped"> <tbody> <tr> <td>PHP</td> <td>date('r', Unix timestamp)</td> </tr> <tr> <td width="200">Java</td> <td>String datetime = new java.text.SimpleDateFormat("dd/MM/yyyy HH:mm:ss").format(new java.util.Date(Unix timestamp * 1000))</td></tr><tr> <td>JavaScript</td> <td>先 var unixTimestamp = new Date(Unix timestamp * 1000) 然后 commonTime = unixTimestamp.toLocaleString()</td></tr><tr> <td>Linux</td> <td>date -d @Unix timestamp</td></tr><tr> <td>MySQL</td> <td>from_unixtime(Unix timestamp)</td></tr><tr> <td>Perl</td> <td>先 my $time = Unix timestamp 然后 my ($sec, $min, $hour, $day, $month, $year) = (localtime($time))[0,1,2,3,4,5,6]</td></tr><tr> <td>PostgreSQL</td> <td>SELECT TIMESTAMP WITH TIME ZONE 'time' + Unix timestamp) * INTERVAL '1 second';</td></tr><tr> <td>Python</td> <td>先 import time 然后 time.gmtime(Unix timestamp)</td></tr><tr> <td>Ruby</td> <td>Time.at(Unix timestamp)</td></tr><tr> <td>SQL Server</td> <td>DATEADD(s, Unix timestamp, '1970-01-01 00:00:00')</td></tr><tr> <td>VBScript / ASP</td> <td>DateAdd("s", Unix timestamp, "01/01/1970 00:00:00")</td></tr> </tbody></table></div> <div class="accordion-group"> </div></div></div></div></div><script src="/static/script/jquery-1.11.3.min.js" type="text/javascript"></script><script src="/static/script/bootstrap.min.js" type="text/javascript"></script><script src="/static/script/tool.js" type="text/javascript"></script><script src="/static/script/unixtime.js" type="text/javascript"></script>{include file="nav" /}
|
||
{include file="link" /}
|
||
{include file="footer" /}
|
||
</body></html> |