Need help. I try to add a select clause in where clause in my query so that it can select the data which is same as the device system date .
my code that work:
(EXTRACT(YEAR FROM W.BrwDate) = '2021')
I try to add select sysdate from dual; so no need to write the specific year and query can be use for every year . But if i combine the code it no work
WHERE (EXTRACT(YEAR FROM RegYear = (select sysdate extract (year from dual))))
So is that any method can solve my mistake?
>Solution :
Should be
where extract (year from regyear) = extract (year from sysdate)