topic Re: current date in Incorta SQL? in Data & Schema Discussions

current date in Incorta SQL?

marcpaige — Thu, 30 Mar 2023 19:06:41 GMT

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.

Re: current date in Incorta SQL?

RADSr — Fri, 31 Mar 2023 13:58:14 GMT

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

Re: current date in Incorta SQL?

marcpaige — Fri, 31 Mar 2023 14:13:06 GMT

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.

Re: current date in Incorta SQL?

mike_mascitti — Fri, 31 Mar 2023 14:37:40 GMT

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.

Re: current date in Incorta SQL?

marcpaige — Fri, 31 Mar 2023 14:52:49 GMT

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.

Re: current date in Incorta SQL?

RADSr — Fri, 31 Mar 2023 15:04:02 GMT

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.