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: How to convert this date to a meaningful date format

Re: How to convert this date to a meaningful date format

From: Joe Smith <nospam_at_nospam.com>
Date: Thu, 21 Aug 2003 10:18:33 +0200
Message-ID: <bi1vd6$38r$1@news-reader3.wanadoo.fr> 




>




> I have a date column whose date formate is like '1061053668503'. How do

> I convert this date format into 'yyyy-mm-dd hh24:mi:ss' ? THANKS!




It seems a timestamp in ms (number of ms from 1 January 1970).



Converting this number in java, it returns:
Sat Aug 16 19:07:48 CEST 2003



I'm not a Oracle expert... just pointing this out so someone else can give
the answer.
Received on Thu Aug 21 2003 - 03:18:33 CDT












Original text of this message













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