79250781

Date: 2024-12-04 10:37:36
Score: 1
Natty:
Report link

In your query you have not mentioned that you want to filter data from 2020 , since you are using sysdate it will give current date and time thats why your query is not working, based on current year it is checking 2024 . try something like this to get all records from 2020:

SELECT * FROM commandes WHERE EXTRACT(YEAR FROM datecommande) = 2020;

Reasons:
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: Arf_code