Date format for ceni and mili seconds

[nir_s]

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]

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

[nir_s]

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]

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

[nir_s]

jmodic,thanks!!