15,047
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→now
(add Format a number) |
(→now) |
||
| Line 13: | Line 13: | ||
* mysql: SELECT UNIX_TIMESTAMP(); //2011-05-30 01:56:38 returns 1306720622 | * mysql: SELECT UNIX_TIMESTAMP(); //2011-05-30 01:56:38 returns 1306720622 | ||
* javascript: [http://stackoverflow.com/questions/221294/how-do-you-get-a-timestamp-in-javascript datetime - How do you get a timestamp in JavaScript? - Stack Overflow] {{access | date = 20110323}} | * javascript: [http://stackoverflow.com/questions/221294/how-do-you-get-a-timestamp-in-javascript datetime - How do you get a timestamp in JavaScript? - Stack Overflow] {{access | date = 20110323}} | ||
* EXCEL: [http://stackoverflow.com/questions/1703505/excel-date-to-unix-timestamp Excel date to Unix timestamp - Stack Overflow] | |||
compare the timestamp and human readable time format | compare the timestamp and human readable time format | ||