Re: Alter a char field

From: gazzag <gareth_at_jamms.org>
Date: 16 Mar 2007 07:31:50 -0700
Message-ID: <1174055510.382669.46230@y66g2000hsf.googlegroups.com>

On 16 Mar, 14:25, "MattJ83" <mattjo..._at_hotmail.co.uk> wrote:
> 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...?

SQL> select to_char(to_date('28/Feb/2007:13:06:37','DD/Mon/ YYYY:HH24:MI:SS'), 'DDMMYYYY') from dual

TO_CHAR(

---

28022007

HTH -g Received on Fri Mar 16 2007 - 09:31:50 CDT