15,008
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→current timestamp in seconds
| Line 56: | Line 56: | ||
** {{kbd | key=<nowiki>echo `TZ=Asia/Taipei date +\%Y-\%m-\%d\ %H:%M:%S` 2>&1</nowiki>}} or {{kbd | key=<nowiki>TZ=Asia/Taipei date +\%Y-\%m-\%d\ %H:%M:%S</nowiki>}} Returns {{Template:Today}} {{CURRENTTIME}}:06 {{exclaim}} force to use Taipei timezone | ** {{kbd | key=<nowiki>echo `TZ=Asia/Taipei date +\%Y-\%m-\%d\ %H:%M:%S` 2>&1</nowiki>}} or {{kbd | key=<nowiki>TZ=Asia/Taipei date +\%Y-\%m-\%d\ %H:%M:%S</nowiki>}} Returns {{Template:Today}} {{CURRENTTIME}}:06 {{exclaim}} force to use Taipei timezone | ||
==== current '''timestamp''' | ==== current '''timestamp''' ==== | ||
The number of seconds since 1970/01/01. [https://zh.wikipedia.org/wiki/UTC%C2%B10 UTC±0] e.g. 2011-05-30 01:56:38 returns 1306720622 | The number of seconds since 1970/01/01. [https://zh.wikipedia.org/wiki/UTC%C2%B10 UTC±0] e.g. 2011-05-30 01:56:38 returns 1306720622 | ||
* BASH for {{Linux}} & {{Mac}}: {{kbd | key=<nowiki>echo $(date +%s)</nowiki>}} "%s - seconds since 1970-01-01 00:00:00 UTC"<ref>[https://linux.die.net/man/1/date date(1): print/set system date/time - Linux man page]</ref> | * BASH for {{Linux}} & {{Mac}}: {{kbd | key=<nowiki>echo $(date +%s)</nowiki>}} "%s - seconds since 1970-01-01 00:00:00 UTC"<ref>[https://linux.die.net/man/1/date date(1): print/set system date/time - Linux man page]</ref> | ||
| Line 76: | Line 76: | ||
*/ | */ | ||
</pre> | </pre> | ||
<div style="width:100%; min-height: .01%; overflow-x: auto;"> | |||
<table border="1" class="wikitable sortable nowrap"> | |||
<tr> | |||
<th>Unit </th> | |||
<th>Example </th> | |||
<th>Approach1: {{kbd | key=date}}</th> | |||
<th>Approach2: {{kbd | key=gdate}}</th> | |||
</tr> | |||
<tr> | |||
<td>(Human readable)</td> | |||
<td>2018-11-04 13:55:52</td> | |||
<td>{{kbd | key=<nowiki>echo $(date '+%Y-%m-%d %H:%M:%S')</nowiki>}} for {{Linux}}, {{Mac}}</td> | |||
<td>{{kbd | key=<nowiki>echo $(gdate '+%Y-%m-%d %H:%M:%S')</nowiki>}} for {{Mac}}</td> | |||
</tr> | |||
<tr> | |||
<td>the number of seconds since 1970/01/01</td> | |||
<td>1541310952</td> | |||
<td>{{kbd | key=<nowiki>echo $(date '+%s')</nowiki>}} for {{Linux}}, {{Mac}}</td> | |||
<td>{{kbd | key=<nowiki>echo $(gdate '+%s')</nowiki>}} for {{Mac}}</td> | |||
</tr> | |||
<tr> | |||
<td>the number of microseconds since 1970/01/01</td> | |||
<td>1541310952.181870</td> | |||
<td>{{kbd | key=<nowiki>printf "%.6f\n" $(date '+%s.%N')</nowiki>}} for {{Linux}}</td> | |||
<td>{{kbd | key=<nowiki>printf "%.6f\n" $(gdate '+%s.%N')</nowiki>}} for {{Mac}}</td> | |||
</tr> | |||
<tr> | |||
<tr> | |||
<td>the number of nanoseconds since 1970/01/01</td> | |||
<td>1541310952.181870383</td> | |||
<td>{{kbd | key=<nowiki>echo $(date '+%s.%N')</nowiki>}} for {{Linux}}</td> | |||
<td>{{kbd | key=<nowiki>echo $(gdate '+%s.%N')</nowiki>}} for {{Mac}}</td> | |||
</tr> | |||
<tr> | |||
</table> | |||
</div> | |||
=== specified time === | === specified time === | ||