Everytime I need to render date and time to a DateTime field, I have to scour the Internet to figure out how. Well, here is how:
If you need to get hourly statistics on your website, select and group by the following metric:
TO_LOCALTIME(QUANTIZE(TO_TIMESTAMP(date, time),3600)) AS Hour
This will properly combine date and time and offset by the correct timezone to a single datetime field recognized by most data parsers. And it will look like this:
2009-01-21 12:00:00
It shouldn't be too difficult to change that to minutes, seconds, periods, whatever you need.