Date format for ceni and mili seconds

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

9i and above - Use timestamp,it's upto 9 fractions of a second.

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

No, no such thing until 9i, at least not with built in DATE datatype.

jmodic,thanks!!