René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
date (datatype in Oracle) | ||
Precision
A date can store a point in time to the precision of one second. If more precision is required, a timestamp datatype is needed.
Valid dates are from January first 4712 BC through December 31st 9999.
Converting to a string
When converted to a string (for example in SQL*Plus), Oracle uses the nls_date_format setting to determine how
the string should look like.
Storage needed
A date always needs seven bytes: two to store the year, one for the month, one for the day, one for the hour, one for the minute and
one for the second.
Links |