hi,
my query
with cte as ( select now() as dt,* from xxx ) select * from cte where dt::date = {{dateOfCreation}}