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: SQL format string for converting epoch time?

Re: SQL format string for converting epoch time?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 13 Aug 2003 00:00:01 +0200
Message-ID: <7ooijv4jmbvbq7f096csuute74ikfquru8@4ax.com> 





On 12 Aug 2003 21:02:58 GMT, revjack <revjack_at_revjack.net> wrote:



>Hello All,

>

>Is there a to_date() format string for converting perl's

>'time' value to Oracle's DATE format?

>

>i.e.  to_date('1060721626', '????????')




there is no real need for that assuming the epoch starts on 1-1-70 and
is a fraction of a day, you would simply
to_date('01-jan-1970','dd-mon-yyyy') + <your epoch time converted to
days>




Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Tue Aug 12 2003 - 17:00:01 CDT












Original text of this message













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