Date format for ceni and mili seconds

**nir_s** · 05-08-2003, 04: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, 04:41 AM

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

**nir_s** · 05-08-2003, 04: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, 08:47 AM

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

**nir_s** · 05-08-2003, 09:41 AM

jmodic,thanks!!

Thread: Date format for ceni and mili seconds

Thread Tools

Display

Date format for ceni and mili seconds

Posting Permissions