RE: Date in milliseconds.
Henk Van Heghe <[email protected]> Mon, 10 Feb 2003 07:43:24 +0100
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-868145-2003.02.10-06.42.48--gcdod-oracle#[email protected]> |
Not possible with DATE datatype. Oracle 9i has a new datatype TIMESTAMP wich makes it possible now. -----Oorspronkelijk bericht----- Van: Bandiatmakur, Ravi [mailto:[email protected]] 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 [email protected].