Hello All,
I'm writing a teradata query in alteryx but for some reason I'm not able to use the current_date keyword. The same query is working fine in teradata sql editor. Could you please advise. Here's the error I'm receiving.
Regards,
Swapsingh
I'm not familiar with Teradata SQL, but if it's at all similar to any other SQL, you haven't identified where to find the information (i.e. a table)
Looking into this, it appears that there may just need to be parentheses at the end. Have you tried that?
SELECT CURRENT_DATE()
try
SELECT CURRENT_DATE;
or
SELECT CURRENT_DATE FROM sys_calendar.calendar WHERE calendar_date = CURRENT_DATE;