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;
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-lReceived on Thu Feb 21 2013 - 15:17:20 CET