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

From: WiseGuy <kanucme_at_notyet.com>
Date: Wed, 20 Aug 2003 07:36:06 -0400
Message-ID: <eVI0b.6191$7F2.5499@fe05.atl2.webusenet.com>

Maybe its a microsoft serial date. I have seen something like it in Excel and Access.

On Wed, 20 Aug 2003 03:21:08 GMT, "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote:

>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
>

MylxHQ - Oracle Resource Portal
http://oracle.mylxhq.com
bsc7080mqc_at_mylxhp.com
(replace mylxhp with mylxhq to reply/contact) Received on Wed Aug 20 2003 - 06:36:06 CDT