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

Convert number to date in Oracle

From: Knorp <ppitarch_at_telefonica.net>
Date: 13 Feb 2006 01:52:18 -0800
Message-ID: <1139824338.175284.3650@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.
Received on Mon Feb 13 2006 - 03:52:18 CST












Original text of this message













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