Hello,
I am working on some query and part of the query needs me to select all the records from AR_CustomerSalesHistory table with FiscalYear equivalent to current year.
I have tried these and some other combinations:
SELECT *
FROM AR_CustomerSalesHistory WHERE FiscalYear = EXTRACT(YEAR FROM CURRENT_DATE())
SELECT *
FROM AR_CustomerSalesHistory WHERE FiscalYear = EXTRACT(YEAR FROM NOW())
But, I get error on this:
[37000] SQL call failed. Unexpected extra token: (
Can somebody please help me with this?
Thanks!
- Vikram