on 03-14-2013 12:16 PM
How can I convert a date format such as "Wednesday,22 January, 1960" using TO_DATE()??
I want to insert the return value of todate() to a date column and Hana accepts date in yyyy-mm-dd format only.
Thanks in advance for help.
Praveen S
Hi Praveen,
Here you go:
select to_date(replace(substr_after('WEDNESDAY,22 January, 1960', ','), ',', ''), 'dd MONTH yyyy') from dummy;
Please find here all the date formats that can be used in the TO_DATE function.
Regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.