PHP and MySQL syntax: Difference between revisions
m →now |
m →now |
||
| Line 45: | Line 45: | ||
SELECT UNIX_TIMESTAMP( ) , FROM_UNIXTIME( UNIX_TIMESTAMP( ) , '%Y-%m-%d %H:%i:%S' ); | SELECT UNIX_TIMESTAMP( ) , FROM_UNIXTIME( UNIX_TIMESTAMP( ) , '%Y-%m-%d %H:%i:%S' ); | ||
/* 1. timezone of UNIX_TIMESTAMP( ) is UTC | /* | ||
1. timezone of UNIX_TIMESTAMP( ) is UTC | |||
2. second part 'FROM_UNIXTIME( UNIX_TIMESTAMP( ) , '%Y-%m-%d %H:%i:%S' )' is server timezone dependent | |||
*/ | */ | ||