Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

HOW CAN I CORRECT THIS SQLITE SYNTAX ERROR

IN MY EMPLOYEE TABLE COLUMN "HIREDATE" HAS (DATETIME) FORMAT AND I AM GETTING ERROR WHEN I TRY RETRIEVE THE DATA BY THIS QUERY BELOW:

SELECT FirstName, HireDate FROM employees
WHERE HireDate (‘2002-08-14 00:00:00”)

I AM GETTING AN ERROR IN SQLITE.

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

Execution finished with errors.
Result: unrecognized token: "’2002-08-14 00:00:00”) "
At line 1:
SELECT FirstName, HireDate FROM employees
–SELECT HireDate FROM employees
WHERE HireDate (

>Solution :

The correct syntax would be:

SELECT FirstName, HireDate FROM employees WHERE HireDate > '2002-08-14 00:00:00'
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading