Current date in sql

How can I return the current date within the SQL editor? The typical mysql/postgres queries don’t work (currdate(), getdate()). Is there a way to use any of the time macros for this?

For context, trying to use the number of days between the current date and a date specified for a calculation.


That should work. Could you please include one of the queries you’re trying to use and if that is MySQL or Postgres data source you’re using.


SELECT NOW() and SELECT CURDATE() worked for me with mysql. Think you might be writing invalid sql.