[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