Search found 3 matches
- Tue Dec 15, 2015 1:19 pm
- Forum: Vertica SQL Functions
- Topic: TO_DATE('0730', 'hh24mi') in Vertica
- Replies: 2
- Views: 16893
Re: TO_DATE('0730', 'hh24mi') in Vertica
Thank you very much..it really worked well
- Mon Dec 14, 2015 4:24 pm
- Forum: Vertica SQL Functions
- Topic: TO_DATE('0730', 'hh24mi') in Vertica
- Replies: 2
- Views: 16893
TO_DATE('0730', 'hh24mi') in Vertica
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, Sre...
- Tue Nov 24, 2015 3:03 pm
- Forum: Vertica SQL Functions
- Topic: NUMTODSINTERVAL equivalent function in Vertica.
- Replies: 1
- Views: 19286
NUMTODSINTERVAL equivalent function in Vertica.
Hi Experts,
I am looking for an equivalent function in Vertica which is similar to NUMTODSINTERVAL function in ORACLE 11g. Could someone please let me know about this?
Regards,
Sreekanth
I am looking for an equivalent function in Vertica which is similar to NUMTODSINTERVAL function in ORACLE 11g. Could someone please let me know about this?
Regards,
Sreekanth