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 protected].