Hello I have date and time table:
date time
09-03-2014 06:17:15
09-03-2014 06:23:06
09-03-2014 06:28:57
09-03-2014 06:40:39
I will make this:
SELECT CONCAT_WS(' ',date,time) AS newtime FROM hive96
newtime
09-03-2014 06:17:15
09-03-2014 06:23:06
09-03-2014 06:28:57
09-03-2014 06:40:39
than later I type this code:
SELECT unix_timestamp('2008-06-19 16:25:15'); <==newtime
I want to collect two query. I want newtime
put in unix timestamp query.
Thank you