[thelist] Oracle Date Swizzle?

Luther, Ron ron.luther at hp.com
Tue Aug 26 12:17:32 CDT 2003


Plunkett, Matt suggested:

>>So, TO_DATE('20031225', 'YYYYMMDD') should do the trick to throw that string
>>into a date.


Hi Matt,


No love ... That gets me "25-12-2003 00:00:00" as a *string* as output.

Thanks for the look though!


RonL.
(Who neglected to mention a "key" piece of information ... I'm using a 
third party report generator tool, BRIO, against the Oracle database.  
The suggested solution would probably work in SQL+ ... but I'm stuck 
where I'm stuck.)


More information about the thelist mailing list