It depends on the database. In general, date and string constants should use single quotes. The SQL standard for a date literal is:
SELECT DATE '2019-11-05'
However, databases might also prefer:
SELECT DATE('2019-11-05')
SELECT CAST('2019-11-05' as DATE)
Or perhaps something else.
CLICK HERE to find out more related problems solutions.