current date in Incorta SQL?

[marcpaige]

This sounds like a trivial question but I have tried all of the options I can think of to get the current date in the where clause for an Incorta SQL table.

I have tried current_date(), getdate(), and $currentDate.

Please let me know how to get the current date in an Incorta SQL table.

[RADSr]

What @mike_mascitti  said - it's not inclusive ( e.g. Postgres has a "mode" function which is cool, but doesn't work w/ Incorta SQL ) but as a Google keyword is pretty helpful.