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: How to convert this date to a meaningful date format

Re: How to convert this date to a meaningful date format

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 20 Aug 2003 03:21:08 GMT
Message-ID: <EOB0b.204100$YN5.142367@sccrnsc01>


Look up to_date in the manual and the date formats. (sql reference) But I do not know what format that is. You are kind of shy on details. Jim
"abjiang" <member35506_at_dbforums.com> wrote in message news:3262392.1061333365_at_dbforums.com...
>
> Hi all,
>
>
>
>
>
> I have a date column whose date formate is like '1061053668503'. How do
> I convert this date format into 'yyyy-mm-dd hh24:mi:ss' ? THANKS!
>
>
>
> ABJIANG
>
>
> --
> Posted via http://dbforums.com
Received on Tue Aug 19 2003 - 22:21:08 CDT

Original text of this message

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