Hello All,
My current query is
select count(*) from dm_user where r_creation_date > DATE('09/01/2019 21:00:00','mm/dd/yyyy HH:MM:SS')
BUT, instead of explicitly specifying the date I want to use date (yesterday) in the above query without changing anything else. This is the requirement.
Eg: select count(*) from dm_user where r_creation_date > DATE('yesterday 21:00:00','mm/dd/yyyy HH:MM:SS')) gives me below error:
Error occured during query execution :[DM_QUERY_E_SYNTAX]error: "A Parser Error (syntax error) has occurred in the vicinity of: select count(*) from dm_user where r_creation_date > DATE(yesterday '21:00:00'"
How can I use Date(yesterday) and time together?
