Date and Time Functions • ADDTIME( expr1 , expr2 ) ADDTIME()  adds  expr2  to  expr1  and returns the result.  expr1  is a time or datetime expression, and expr2  is a time expression. • CONVERT_TZ( dt , from_tz , to_tz ) • CURDATE() • CURRENT_DATE ,  CURRENT_DATE() • CURRENT_TIME ,  CURRENT_TIME([ fsp ]) • CURRENT_TIMESTAMP ,  CURRENT_TIMESTAMP([ fsp ]) • CURTIME([ fsp ]) Returns the current time as a value in  ’hh:mm:ss’  or  hhmmss  format, depending on whether the function is used in string or numeric context. The value is expressed in the session time zone. If the  fsp  argument is given to specify a fractional seconds precision from 0 to 6, the return value includes a fractional seconds part of that many digits. CURRENT_TIMESTAMP  and  CURRENT_TIMESTAMP()  are synonyms for  NOW() . CURRENT_TIME  and  CURRENT_TIME()  are synonyms for  CURTIME() . CURRENT_DATE  and  CURRENT_DATE()  are synonyms for  CURDATE() . Returns the current date as a value in  ’ YYYY-MM-DD ’  or  YYYYMMDD  format, depending on whether the function is used in string or numeric context. If the value falls out of the supported range of the  TIMESTAMP  type when converted from  from_tz  to UTC, no conversion occurs. The  TIMESTAMP  range is described in Section 11.2.1, “Date and Time Data Type Syntax” . CONVERT_TZ()  converts a datetime value  dt  from the time zone given by  from_tz  to the time zone given by  to_tz  and returns the resulting value. Time zones are specified as described in Section 5.1.15, “MySQL Server Time Zone Support” . This function returns  NULL  if the arguments are invalid. mysql>  SELECT ADDTIME(’2007-12-31 23:59:59.999999’, ’1 1:1:1.000002’); -> ’2008-01-02 01:01:01.000001’ mysql>  SELECT ADDTIME(’01:00:00.999999’, ’02:00:00.999998’); -> ’03:00:01.999997’ mysql>  SELECT CONVERT_TZ(’2004-01-01 12:00:00’,’GMT’,’MET’); -> ’2004-01-01 13:00:00’ mysql>  SELECT CONVERT_TZ(’2004-01-01 12:00:00’,’+00:00’,’+10:00’); -> ’2004-01-01 22:00:00’ mysql>  SELECT CURDATE(); -> ’2008-06-13’ mysql>  SELECT CURDATE() + 0; -> 20080613 Note To use named time zones such as  ’MET’  or  ’Europe/Amsterdam’ , the time zone tables must be properly set up. For instructions, see Section 5.1.15, “MySQL Server Time Zone Support” . 2153