MySQL in a Nutshell, 2nd Edition

Name

TIMESTAMP()

Synopsis

TIMESTAMP(date, time)

This function merges the date and time from given strings or columns that contain date and time data separately; the result is returned in yyyy-mm-dd hh:mm:ss format. If only the date or only the time is given, the function will return zeros for the missing parameter. It’s available as of version 4.1.1 of MySQL. Here is an example:

SELECT TIMESTAMP(appt_date, appt_time) AS 'Appointment'
FROM appointments LIMIT 1;

+---------------------+
| Appointment         |
+---------------------+
| 2008-07-16 11:13:41 | 
+---------------------+