Re: Alter a char field

On Mar 16, 6:41 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> 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...

Hi Frank,

I was using the CHAR field because i had characters in the field....i wanted to get rid of these characters so that i could put the numbers in a NUMBER field Received on Tue Mar 20 2007 - 06:02:55 CDT