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 · Accepted solution]

CURRENT_DATE  ( w/ the underscore ) will get you there.

[marcpaige]

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.

[mike_mascitti]

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.

[marcpaige]

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.