Unable to use teradata function 'current_date' i n alteryx

[swapsingh2712]

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

[jdminton]

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()

[binu_acs]

@swapsingh2712 

try 
SELECT CURRENT_DATE;
or
SELECT CURRENT_DATE FROM sys_calendar.calendar WHERE calendar_date = CURRENT_DATE;