15,047
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→terms of time format
| Line 9: | Line 9: | ||
<td> 1970/1/1</td> | <td> 1970/1/1</td> | ||
<td> 2016/1/1 </td> | <td> 2016/1/1 </td> | ||
</tr> | |||
<tr> | |||
<td> column value of unix timestamp <br /> (the number of seconds since 1970/01/01)</td> | |||
<td> -2209075200</td> | |||
<td> 0</td> | |||
<td> 1451606400</td> | |||
</tr> | </tr> | ||
<tr> | <tr> | ||
| Line 15: | Line 21: | ||
<td> 25569</td> | <td> 25569</td> | ||
<td> 42370</td> | <td> 42370</td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
=== now === | === now === | ||
Convert '''unix timestamp''' (the number of seconds since 1970/01/01) <--> to the '''human readable''' time format ex: {{Template:Today}} {{CURRENTTIME}}:06 | Convert '''unix timestamp''' (the number of seconds since 1970/01/01) <--> to the '''human readable''' time format ex: {{Template:Today}} {{CURRENTTIME}}:06 | ||