gregor gregor - 4 months ago 38
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);