| Date format - milliseconds!!! [message #53398] |
Wed, 18 September 2002 01:05  |
Nikhil Marathe
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
I would be obliged to know if there is any way to store and retrieve dates in Oracle to the precision of milliseconds. If no, then are there any databases which support this feature?
Thanks and regards
Nikhil
|
|
|
|
|
|
|
|
| Re: correction [message #53417 is a reply to message #53405] |
Wed, 18 September 2002 11:59  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
To store date&time down to millisec in 8i and earlier, you need to store the value in a varchar column. See TIMESTAMP column in USER_OBJECTS. Although you may not see millisec discplayed there, you could. It depends on how the data got in there. Note that you need to store your string representation in descending significance (yyyy mm dd hh24 mi ss millisec) if you want to be able to sort on it. Of course you still cant do date arithmetic on it... SYSDATE and date formats don't go down to millisec either, so you need to get the value externally (as Mahesh said).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
