FairCom Corporation
 
FairCom Start PageFairCom ProductsDownloadsDeveloper SupportSales InformationFairCom CustomersFairCom Company InformationContact FairCom

Homebulletgrey.gifeNewsletterbulletgrey.gifVolume 22bulletgrey.gifc- 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.

Since its inception in 1979, Software Technology, Inc. (STI) has been developing, marketing, selling and supporting computer software for the legal and accounting markets. STI develops Tabs3, one of the most widely used professional time and billing systems in the North America. Professionals in solo, small and medium sized firms have depended on Tabs3 for their timekeeping, billing and reporting needs. A complementary product to Tabs3 is STI's PracticeMaster practice management system. This powerful application has been highly acclaimed for its flexible customization and integration capabilities, and is considered one of the best practice management systems on the market today.

STI has used c-tree Plus for their data management needs for many years. Their applications use a blend of FairCom's peer-to-peer and client/server models. The flexibility of FairCom's technology allows STI to deliver the operational model that best suits the needs of individual customers.

(460KB PDF)

FairCom Start PageSite MapContact FairComThe FairCom Privacy Policy Your Location: USA | Europe | Brazil | Japan
Copyright 2010 FairCom Corporation. All rights reserved.