Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Concatenate

Re: Concatenate

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 17 Mar 2006 03:06:44 -0800
Message-ID: <1142593604.643110.45560@p10g2000cwp.googlegroups.com>

Reiro wrote:
> hi Rauf..
>
> what if i get the date in this format 20060316 yyyymmdd. and store it
> as a number for upload.
> what changes do i make to the query to receive the same output.

to_char(20060316) will convert this to a varchar. to_date(to_char(20060316), 'YYYYMMDD') will convert this to a date.

You should be able to figure it out from here. It's all documented at http://tahiti.oracle.com.

Regards
/Rauf Received on Fri Mar 17 2006 - 05:06:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US