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

RADSr
Captain
Captain
CURRENT_DATE  ( w/ the underscore ) will get you there.
-- IncortaOne@PMsquare.com --

marcpaige
Astronaut

Thank you so much. I knew it must be simple. How did you find this out? I couldn't find this in any documentation or in the community.

I haven't used Incorta SQL tables yet, but CURRENT_DATE is the method used in Postgres for retrieving the current date.  Perhaps the Incorta SQL tables follow Postgres syntax and rules.

Yes, that makes sense. I couldn't find any reference material that would indicate that. The fact that RADSr's solution worked suggests that it is the case.