SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fractions of Seconds in Date

200938Oct 8 2002

I am converting data from Sybase to Oracle. In Sybase my date field contains the month, day, year, hour, minutes, seconds, and fractions of seconds i.e. Jul 26 1999 5:12:04:000PM and Jul 26 1999 5:12:04:990PM. these two entries are causing duplicate entries in Oracle. Does Oracle store times in less than 1 second increments and if so, what is the date format to view them?

Thanks,

Veronica

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2002

Added on Oct 8 2002

3 comments

573 views