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 -> converting timestamp in milliseconds to date or vice-versa in oracle

converting timestamp in milliseconds to date or vice-versa in oracle

From: <ameyas7_at_yahoo.com>
Date: 4 Feb 2005 06:04:44 -0800
Message-ID: <1107525884.144586.315700@z14g2000cwz.googlegroups.com> 





hey folks,



we have a varchar2 col which stores the timestamps (records r added frm
java app which logs the currentTimeInMillis on that System)
now i want to write a procedure which will delete records older than
say 45 days


i can get the current date using sysdate but this is in DATE format
whereas my column is in varchar2 (also the value is in millis)
how do i convert from millis to date or vice-versa 




regards


amey
Received on Fri Feb 04 2005 - 08:04:44 CST












Original text of this message













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