Click to See Complete Forum and Search --> : Date format for ceni and mili seconds


nir_s
05-08-2003, 05:32 AM
Hi guys,

I suppose to display in my application a date field in date format which includs centi seconds and mili seconds.
How to do it?

Thanks in advance,
Nir

Tarry
05-08-2003, 05:41 AM
9i and above - Use timestamp,it's upto 9 fractions of a second.

nir_s
05-08-2003, 05:50 AM
Hi Tarry,

Thanks!!
We have Oracle 8.1.7.3
If i understand you well,there is no such an option in oracle 8i,isn't it?

Nir

jmodic
05-08-2003, 09:47 AM
No, no such thing until 9i, at least not with built in DATE datatype.

nir_s
05-08-2003, 10:41 AM
jmodic,thanks!!