Home
eNewsletterVolume 22c- treeSQL Date Types
Differences With c- treeSQL Date Types
The following query on a table containing a Date field can return unexpected rows:
SELECT * FROM myTable WHERE myDate >= '0001-01-01' AND myDate <= '9999-01-01'
However, this query returns the expected set of rows.
SELECT * FROM myTable WHERE myDate >= '1700-03-01' AND myDate <= '9999-01-01'
Why the difference? The c-tree Plus Date field type stores dates as an unsigned four byte integer representing the number of days since 02/28/1700. Hence the first valid date is 03/01/1700. Date values before this date can result in unexpected results. Thus, when performing c-treeSQL queries on date data, keep in mind the c-tree Plus 2/28/1700 epoch starting value.
Computer Associates International, Inc (NYSE: CA) has been developing and supporting software solutions for more than 99% of the Fortune 500® in more than 100 countries for over a quarter century. CA's world-class solutions address all aspects of eBusiness process management, information management, and infrastructure management in six focus areas: enterprise management, security, storage, portal and business intelligence, database management, application life cycle management, and application development. As the world's third largest enterprise software company, CA provides industry-leading integrated solutions through strategic partnerships and powerful brands such as Unicenter®, BrightStor™, eTrust™, CleverPath™, Advantage™, Jasmine® and AllFusion™. With mission-critical software in security and storage, CA provides reliable, quality technology. CA works hard to achieve the highest quality in their solutions to help their customers meet changing business needs. That's why CA became the first and only global enterprise software company to meet the exacting standards for worldwide ISO 9002 certification.
Advantage™ CA-Realia® II Workbench™ provides a mainframe-compatible COBOL development environment on the PC. It uses the power of the PC environment to improve the development and maintenance of COBOL and CICS applications. FairCom's c-tree Plus provides the underlying technology for the runtime file system of Advantage CA-Realia II Workbench. Computer Associates selected FairCom technology for this application because of the strength and flexibility of c-tree Plus and the flexibility of FairCom's business models.
(727KB PDF)
