how do i correctly put the date in sql form?

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.

Leave a Comment

Your email address will not be published.

Scroll to Top