To declare datetime variable and then use it in a query?

[janemrosupc47a]

Hi, how can I declare datetime variable and then use it in a query?

For example:

 

[janemrosupc47a]

https://s3.amazonaws.com/mro-supply-sharex/2020/07/Slack_CC5ly9QLO7.png 

[janemrosupc47a]

any answer?

[websterlove_wl · Accepted solution]

Hi,

The SQL Report Builder doesn't support variable declaration syntax like your example - try a WITH clause at the beginning. You can use this to effectively create a temporary table, which you can then select your variable from.

For example:

with tmp as
  (select '2020-08-20'::DATE as mydate
  )
select "entity_id", "created_at"
from "sales_order"
where "created_at" >= (select mydate from tmp)
limit 10;