dynamobi/dynamobi — Issue #671: [FRG-201] Extract function does not support subsecond precision for intervals
Author: dynamobi-build
Created: 2011-12-30 03:42:29+00:00
State: open
Labels: Database, FRG

[reporter="angel", created="Mon, 11 Sep 2006 23:11:56 -0500 (GMT-05:00)"]
Subsecond precision is not supported by the Extract funciton (note that extracting from datetime types is also not supported, only interval types are supported right now)

To support subsecond precision, see TODOs in SqlExtractFunction and StandardConvertletTable.convertExtract.

1. In SqlExtractFunction, the return type should be changed from so that it is SqlTypeStategies.rtiNullableBigint if the extract field doesn't have second, and is a suitable decimal type (with the appropriate precision), if seconds are involved. See SQL 2003, chapter 2, section 6.27. syntax rules 4, 5.

2. convertExtract need to be updated to handle decimal seconds

3. Should also add tests to SqlOperatorTests.testExtractFunc