TO_DATE('0730', 'hh24mi') in Vertica
Posted: Mon Dec 14, 2015 4:24 pm
Hi Experts,
I need help in converting the below query into Vertica.
The below is the output I get when the query is run in Oracle.
SELECT TO_CHAR(TO_DATE('0730', 'hh24mi'),'HH24:MI') AS TIME1 FROM DUAL
--07:30
I wanted to get the same result in Vertica. Could you please help me on this?
Regards,
Sreekanth
I need help in converting the below query into Vertica.
The below is the output I get when the query is run in Oracle.
SELECT TO_CHAR(TO_DATE('0730', 'hh24mi'),'HH24:MI') AS TIME1 FROM DUAL
--07:30
I wanted to get the same result in Vertica. Could you please help me on this?
Regards,
Sreekanth