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