PHP and MySQL syntax: Difference between revisions

Jump to navigation Jump to search
Line 61: Line 61:
  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
  1st column: timezone of UNIX_TIMESTAMP( ) is UTC
  2. second part 'FROM_UNIXTIME( UNIX_TIMESTAMP( ) ,  '%Y-%m-%d %H:%i:%S' )' is server timezone dependent
  2nd column: 'FROM_UNIXTIME( UNIX_TIMESTAMP( ) ,  '%Y-%m-%d %H:%i:%S' )' is server timezone dependent
  */
  */


Navigation menu