COnverting SQL Date into SQL DateTime

[Sascha_S]

Or you could try the TIMESTAMP(date, time) function to join both fields/columns on the fly.

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_timestamp