RE: Date in milliseconds.

Not possible with DATE datatype.
Oracle 9i has a new datatype TIMESTAMP wich makes it possible now.

-----Oorspronkelijk bericht-----
Van: Bandiatmakur, Ravi [mailto:Ravi_Bandiatmakur@xxxxxxxxxxxxx]
Verzonden: maandag 10 februari 2003 6:12
Aan: Oracle
Onderwerp: [oracle] Date in milliseconds.


Hi all,

I want to store a date with timestamp(HH:MI:SS:MS) in DATE datatype in
oracle8i. As far as my knowledge we can store a date with
timestamp(HH:MI:SS) until seconds. But I want to store a date with timestamp
until milli seconds.

For example:

I can store a date with timestamp until seconds . 

INSERT INTO ADB.X12DOCGROUPS(GS_DATE) 
VALUES (TO_DATE('20030210112233','YYYYMMDD HHMISS')) 

My doubt is, how do i store a date with milliseconds?

Any help would be appreciated.

Thanks,
Ravi.

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to leave-oracle-1796914O@xxxxxxxxxxxxx