PHP and MySQL syntax: Difference between revisions

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


Navigation menu