How to use CURRENT_DATE() in a SQL script?

Get Help
1

hello everyone，

I have some SQL Scripts like below:
[[where I.FREALPROCESSFINISHTIME BETWEEN (select CONVERT(varchar(10),{{start_date}},120)+' 08:00:00') AND (select CONVERT(varchar(10),DATEADD(day,1,{{end_date}}),120)+' 08:00:00')]]

and I want to set {{start_date}} and {{end_date}} both default today.
I find the CURRENT_DATE() but dont know how to insert it.

2

Hi @ljqPro
You would use Complex Default Value:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#setting-complex-default-values-in-the-query

WHERE TRUE
  AND 
    [[I.FREALPROCESSFINISHTIME BETWEEN CONVERT(varchar(10),{{start_date}},120)+' 08:00:00' AND CONVERT(varchar(10),DATEADD(day,1,{{end_date}}),120)+' 08:00:00' #]] CAST(I.FREALPROCESSFINISHTIME AS DATE) = CURRENT_DATE()

So when you don't input variables, then the query would be:

WHERE TRUE AND CAST(I.FREALPROCESSFINISHTIME AS DATE) = CURRENT_DATE()