gregor gregor - 8 months ago 53
MySQL Question

Creating DATETIME from DATE and TIME

Is there way in MySQL to create DATETIME from a given attribute of type DATE and a given attribute of type TIME?

Zed Zed
Answer
datetime = CONCAT(date, ' ', time);