Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Concatenate
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