MySql, combining date and time column into a time stamp

Or you could use the built-in TIMESTAMP(date,time) function.

So then you would do something like this say from an Orders table…

SELECT OrderNumber, TIMESTAMP(date,time) as OrderTS, SalesPersonID
FROM Orders