PHP and MySQL syntax: Difference between revisions

PHP and MySQL syntax (edit)

158 bytes added , 9 March 2016

m

14,983

edits

@@ Line 45: / Line 45: @@
   SELECT UNIX_TIMESTAMP( ) , FROM_UNIXTIME( UNIX_TIMESTAMP( ) ,  '%Y-%m-%d %H:%i:%S' );
+ /* 1. timezone of UNIX_TIMESTAMP( ) is UTC
+. second part 'FROM_UNIXTIME( UNIX_TIMESTAMP( ) ,  '%Y-%m-%d %H:%i:%S' )' is server timezone dependent
+ */
 today