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: TO_CHAR display hundreth of seconds

Re: TO_CHAR display hundreth of seconds

From: Gabriel Gonzalez <no-spam_at_no-spam.com>
Date: Thu, 20 Mar 2003 12:45:41 -0800
Message-ID: <AHCdndTi2Yueu-ejXTWcig@giganews.com> 





DATE is not the correct data type for that (the fractions of a second anre
not stored in a DATE).  Look at TIMESTAMP.  (assuming you have Oracle 9)



"LHradowy" <laura.hradowy_at_NOSPAM.mts.ca> wrote in message
news:9upea.1146$_g3.3806_at_news1.mts.net...


> I need to TO_CHAR a date that will include the time with it down to the

> hundredth of a second, how would I do it?

>

> Sorry I am a newbie

>

>

Received on Thu Mar 20 2003 - 14:45:41 CST












Original text of this message













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