Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Date Time Format and milliseconds

Re: Date Time Format and milliseconds

From: Rolf Hauck <Rolf.Hauck_at_datenrevision.de>
Date: Mon, 19 Oct 1998 14:42:29 +0200
Message-ID: <362B33B5.EA8E1ADF@datenrevision.de> 





No chance. The date datatype doesn't include milliseconds, so you can't
get them by playing around with NLS_DATE_FORMAT. Resolution of date ist
seconds. :-((



Rolf



Moonstone wrote:


> 


> Hi,


> is there a way to store milliseconds in a date field.


> I tried to play around with the NLS_DATE_FORMAT but I didn't  succeed until


> now:


> Any sugesstions ?


> 


> Cheers


> Eric


Received on Mon Oct 19 1998 - 07:42:29 CDT












Original text of this message













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