DATE - Firebird
Interview Questions
All Tutorials
Job SearchIn dialect 3, DATE stores the date alone, with no time portion: “date-only.” Storage is a 32-bit signed integer. Storable dates range from January 1, 0001, to December 31, 9999.
In dialect 1, the DATE type is equivalent to a dialect 3 TIMESTAMP. Indeed, when you create a new date column in a dialect 1 database, using isql , a warning will appear informing you that the type has been renamed! SQLTYPE is isc_timestamp.
There is no “date-only” type in dialect 1. To store a dialect 1 type and make it date only, pass a valid date and time literal with ' 00:00:00.0000' in the time portion. Date and time literals are discussed in greater detail in the following sections.
