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: Convert number to date in Oracle

Re: Convert number to date in Oracle

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 13 Feb 2006 06:03:33 -0500
Message-ID: <E72dnYedDPwa-m3enZ2dnUVZ_tqdnZ2d@comcast.com>

"Knorp" <ppitarch_at_telefonica.net> wrote in message news:1139824338.175284.3650_at_g14g2000cwa.googlegroups.com...
: Hi,
:
: I have a table where dates are stored as numbers (seconds since
: 1/1/1970) and I want to generate a query to show them as dates with the
: format DD/MM/YYYY hh:mm:ss.
:
: Which conversion functions should I use?
:
: Thank you in advance.
:

to_date to convert them to oracle's internal date format (which will actually first do an implicit to_char)

then to_char to get he format you want

++ mcs Received on Mon Feb 13 2006 - 05:03:33 CST

Original text of this message

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