This content has been marked as final.
Show 2 replies
-
1. Re: how can i save timestamp in oracle
scoy Nov 7, 2002 10:25 PM (in response to agroeschl)java.sql.TimeStamp stores date-time values down to the millisecond, so it has a granularity of milliseconds.
oracle 8's DATE type stores date-time values down to whole seconds only. You will lose the milliseconds component.
There's no note for Oracle 9i, either, because it has a TIMESTAMP data type.
If you must user Oracle 8, then you will have to store the timestamp as a numeric type.
Steve -
2. Re: how can i save timestamp in oracle
agroeschl Nov 7, 2002 10:35 PM (in response to agroeschl)thanks steve, for your fast help.