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
@swapsingh2712
try SELECT CURRENT_DATE; or SELECT CURRENT_DATE FROM sys_calendar.calendar WHERE calendar_date = CURRENT_DATE;
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()
