STR_TO_DATE returning null
Posted by:
Jim Palmer
Date: March 22, 2018 06:59AM
Hi,
I have a CSV that contains dates in m/d/yy (i.e. 1/3/09) format, that I would like to convert to a proper date 2009-01-03.
To test this I coded -
select STR_TO_DATE('1/3/09','m%/%d/%y');
select STR_TO_DATE('1/3/09','m%/%d/%Y');
and both queries return null.
What am I doing wrong?
Help appreciated.
-JP
Subject
Written By
Posted
STR_TO_DATE returning null
March 22, 2018 06:59AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.