Re: TO_DATE ignores

From: Fergal Taheny <ftaheny_at_gmail.com>
Date: Thu, 21 Feb 2013 14:17:20 +0000
Message-ID: <CAOuMUT4Wh05ordbjecUGmP5pSvN37p2L=B9Qd2uxhZki0FUrKw_at_mail.gmail.com>



Hi Joel,
select to_date('01-JAN-01','FXDD/MM/YYYY') from dual;

Thanks a million. That's exactly what I need. I wasn't aware of the FX modifier.

And thanks Norman too!

Regards,
Fergal

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 21 2013 - 15:17:20 CET

Original text of this message