Re: Convert an integer date

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 11 Nov 1999 09:31:34 -0500
Message-ID: <OdMqOPmOupzO3EHpbGlg+2+TcVgG@4ax.com>

A copy of this was sent to vigi98_at_my-deja.com (if that email address didn't require changing) On Thu, 11 Nov 1999 07:09:50 GMT, you wrote:

>Hello evrybody,
>
>Sorry for this question you should have seen thousands times but I
>don't find the answer.
>
>Does anybody know how to convert, in an Oracle request, an integer
>formated date (the number of seconds since 1970, I assume) to a normaly
>formated date, that is to say dd/mm/yyyy. I know it must be with the
>to_date keyword, but what is exactly the syntax ?
>

see http://osi.oracle.com/~tkyte/Misc/CTime.html

>Thanks a lot for your answers.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Nov 11 1999 - 08:31:34 CST