content_image/733333.jpg
## • 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. 

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’ 

## • CONVERT_TZ( dt , from_tz , to_tz ) 

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. 

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” . 

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’ 

<img src='content_image/733333.jpg'>

## • CURDATE() 

## 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” . 

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. 

mysql> SELECT CURDATE(); -> ’2008-06-13’ mysql> SELECT CURDATE() + 0; -> 20080613 

## • CURRENT_DATE , CURRENT_DATE() 

CURRENT_DATE  and CURRENT_DATE()  are synonyms for CURDATE() . 

## • CURRENT_TIME , CURRENT_TIME([ fsp ]) 

CURRENT_TIME  and CURRENT_TIME()  are synonyms for CURTIME() . 

## • CURRENT_TIMESTAMP , CURRENT_TIMESTAMP([ fsp ]) 

CURRENT_TIMESTAMP  and CURRENT_TIMESTAMP()  are synonyms for NOW() . 

## • 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. 

