René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -

date (datatype in Oracle)


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.