Date/Time Math in SuiteQL

Hello,

I am extracting data via SuiteQL using the Suiteanalytics Connect ODBC driver.

Some of the use cases include various date and datetime output columns as well as date and datetime predicates.

This article by Tim Dietrich implies that we can simply add a fractional day to a DATE datatype.

However, this does not appear to work when using performing date math in predicates.

This works:

select top 1 sysdate + (1/24) from task

This fails:

select top 1 * from task where lastmodifiedate >= (sysdate - (1/24))

"Error getting the literal value of right operand.[10169]"

There are also failure cases involving TO_DATE but let's discuss this first.