Xref: alice comp.databases.oracle.server:73467
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: vigi98@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Convert an integer date
Date: Thu, 11 Nov 1999 07:09:50 GMT
Organization: Deja.com - Before you buy.
Lines: 15
Message-ID: <80dq3r$8h4$1@nnrp1.deja.com>
X-Article-Creation-Date: Thu Nov 11 07:09:50 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 95)
X-Http-Proxy: 1.1 x29.deja.com:80 (Squid/1.1.22) for client 212.249.240.105
X-MyDeja-Info: XMYDJUIDvigi98

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 ?

Thanks a lot for your answers.


Sent via Deja.com http://www.deja.com/
Before you buy.