|
|
In 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.
|
|
Firebird Related Tutorials |
|
---|---|
MySQL Tutorial | Linux Tutorial |
Windows 10 Tutorial | Windows 10 Development Tutorial |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.