03-30-2023 12:06 PM
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.
Solved! Go to Solution.
03-31-2023 06:58 AM
03-31-2023 07:13 AM
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.
03-31-2023 07:37 AM
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.
03-31-2023 07:52 AM
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.