In queries in the SQL language for MySQL, the dates in date type fields must be expressed in quotes. This is: insert into table (date) values (‘1995-01-29’) The date field in the above SQL query is assumed to be a MySQL date field. You could also have expressed the date in double quotes.
Insert a date field in MySQL
- Facebook Comments
- Disqus