Previous Topic

Next Topic

Correct c-treeACE SQL EXTRACT Scalar Function Ranges

A query such as the following returned an unexpected overflow error:

SELECT EXTRACT(DAY from '03-31-2009') from syscalctable; 

The scalar function EXTRACT failed to properly handle correct day ranges for all dates. The range checks have been modified to correctly process all valid date ranges.