MySQL Tutorial/Date Time Functions/TIMESTAMP

TIMESTAMP(expr1,expr2) adds the time expression expr2 to the date or datetime expression expr1 and returns the result as a datetime value.

   <source lang="sql">

mysql> mysql> mysql> SELECT TIMESTAMP("2003-12-31 12:00:00","12:00:00"); +---------------------------------------------+ | TIMESTAMP("2003-12-31 12:00:00","12:00:00") | +---------------------------------------------+ | 2004-01-01 00:00:00 | +---------------------------------------------+ 1 row in set (0.00 sec) mysql></source>

TIMESTAMP(expr) returns the date or datetime expression expr as a datetime value

   <source lang="sql">

mysql> mysql> SELECT TIMESTAMP("2003-12-31"); +-------------------------+ | TIMESTAMP("2003-12-31") | +-------------------------+ | 2003-12-31 00:00:00 | +-------------------------+ 1 row in set (0.00 sec) mysql></source>