[thelist] Oracle Date Swizzle?
Plunkett, Matt
MPlunkett at MSA.com
Tue Aug 26 13:03:26 CDT 2003
-----Original Message-----
From: Luther, Ron [mailto:ron.luther at hp.com]
Sent: Tuesday, August 26, 2003 1:18 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Oracle Date Swizzle?
Plunkett, Matt suggested:
>>>So, TO_DATE('20031225', 'YYYYMMDD') should do the trick to throw that
string
>>into a date.
> No love ... That gets me "25-12-2003 00:00:00" as a *string* as output.
Hrm. That suggests it is converting it somewhat though. Is it possible
that what you're printing out is being converted to VARCHAR for print
purposes? I would try monkeying with it more, but I can't help beyond
standard Oracle stuff sorry.
What are you doing with this date once you get it converted?
More information about the thelist
mailing list