MattJ83 schreef:
> ok..i have a feeling this is a simple procedure.
> Basically I have a CHAR field with the date in and I would like to
> turn this into a string of numbers.
>
> Eg:
> "28/Feb/2007:13:06:37" ---> "28022007"
>
> Im not sure if i need to put the date into a date field first before i
> can get this information...?
>
gazzag provided you with an answer, but why do you store dates
in a character field?
Why do you use CHAR, and not VARCHAR2?
Why do you store a number in a character field?
Sigh...
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Fri Mar 16 2007 - 13:41:01 CDT
