Date/Time Conversions?

From: <grider22_at_my-deja.com>
Date: Tue, 01 Jun 1999 18:47:50 GMT
Message-ID: <7j19sm$su$1@nnrp2.deja.com>

Hi,

I have a character string: '19990315' that I need to derive into a date field. However, when I use the TO_DATE function it will convert '19990315' to '15-MAR-1999'. This format gives me an invalid date error. Is there anyway to convert '19990315' string into a date but still retain the same format? I would also like to do the same thing for a time string of '1450' and derive this into a time field.

Thanks,
Stephen

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 01 1999 - 13:47:50 CDT