14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→current timestamp
| Line 90: | Line 90: | ||
<td>(Human readable)</td> | <td>(Human readable)</td> | ||
<td>2018-11-04 13:55:52</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 $(date '+%Y-%m-%d %H:%M:%S')</nowiki>}} for {{Linux}}, {{Mac}} & CygWin on {{Win}}</td> | ||
<td>{{kbd | key=<nowiki>echo $(gdate '+%Y-%m-%d %H:%M:%S')</nowiki>}} for {{Mac}}</td> | <td>{{kbd | key=<nowiki>echo $(gdate '+%Y-%m-%d %H:%M:%S')</nowiki>}} for {{Mac}}</td> | ||
</tr> | </tr> | ||
| Line 96: | Line 96: | ||
<td>the number of seconds since 1970/01/01</td> | <td>the number of seconds since 1970/01/01</td> | ||
<td>1541310952</td> | <td>1541310952</td> | ||
<td>{{kbd | key=<nowiki>echo $(date '+%s')</nowiki>}} for {{Linux}}, {{Mac}}</td> | <td>{{kbd | key=<nowiki>echo $(date '+%s')</nowiki>}} for {{Linux}}, {{Mac}} & CygWin on {{Win}}</td> | ||
<td>{{kbd | key=<nowiki>echo $(gdate '+%s')</nowiki>}} for {{Mac}}</td> | <td>{{kbd | key=<nowiki>echo $(gdate '+%s')</nowiki>}} for {{Mac}}</td> | ||
</tr> | </tr> | ||
| Line 102: | Line 102: | ||
<td>the number of microseconds since 1970/01/01</td> | <td>the number of microseconds since 1970/01/01</td> | ||
<td>1541310952.181870</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" $(date '+%s.%N')</nowiki>}} for {{Linux}} & CygWin on {{Win}}</td> | ||
<td>{{kbd | key=<nowiki>printf "%.6f\n" $(gdate '+%s.%N')</nowiki>}} for {{Mac}}</td> | <td>{{kbd | key=<nowiki>printf "%.6f\n" $(gdate '+%s.%N')</nowiki>}} for {{Mac}}</td> | ||
</tr> | </tr> | ||
| Line 109: | Line 109: | ||
<td>the number of nanoseconds since 1970/01/01</td> | <td>the number of nanoseconds since 1970/01/01</td> | ||
<td>1541310952.181870383</td> | <td>1541310952.181870383</td> | ||
<td>{{kbd | key=<nowiki>echo $(date '+%s.%N')</nowiki>}} for {{Linux}}</td> | <td>{{kbd | key=<nowiki>echo $(date '+%s.%N')</nowiki>}} for {{Linux}} & CygWin on {{Win}}</td> | ||
<td>{{kbd | key=<nowiki>echo $(gdate '+%s.%N')</nowiki>}} for {{Mac}}</td> | <td>{{kbd | key=<nowiki>echo $(gdate '+%s.%N')</nowiki>}} for {{Mac}}</td> | ||
</tr> | </tr> | ||