Oracle silently truncates dates

According to the documentation, the Oracle DATE type does not store fractions of a second. So if you store a date/time value including fractions of a second and read it back, you’ll get back a slightly different date/time. This will cause exact date matching code in your appplication to fail.

Share This | Comments | Permalink | Trackback | Comments feed

Post a comment

(required)
(required)
Close
E-mail It