cancel
Showing results for 
Search instead for 
Did you mean: 

current date in Incorta SQL?

marcpaige
Astronaut

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.

5 REPLIES 5

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.

-- IncortaOne@PMsquare.com --