Date Math Functions supported for In Database Connections

Most modern databases (sql server, oracle, teradata, cloudera, etc) support some level of date manipulation functions like dateadd(), add_months(), datediff(), getdate(), etc. Currently Spotfire doesn't support any of these functions across the majority of our in database connectors unless you pull the dataset in memory which is limiting especially for large datasets. For example, the Cloudera Impala connector supports some of these (date_add(),datediff(), etc) but Oracle, SQL Server, Teradata, Redshift and others don't support any of them.

Because of this limitation, its either impossible or extremely difficult to use in database connectors without resorting to writing custom sql to handle any type of rolling date logic. This is a big knock especially compared to our competitors in this space.

At a minimum, we should have the ability to return the current date when working in database as well as doing basic date math such as adding or removing date units (hours, days, months, etc) and determining differences between 2 dates.