Error code 1064

Hi
I’m trying to build one database.

USE mydb;
CREATE TABLE doughnut_ratings
(location VARCHAR(100),time1 time,date1 DATE,type1 VARCHAR(100), rating INT,comments VARCHAR(100));
INSERT INTO doughnut_ratings(location,time1,date1,type1,rating,comments) VALUES
(‘Krispy King’, ‘8:50’,
9/27/1992,‘plain glazed’,
10,‘almost perfect’);

Now i’m not able to understand the what should be the correct way to mention time and date for their respective datatype.
Please help me to understand the same.

It depends on the database, but in sqlite3 you use the DATETIME or TIME, or DATE format:

https://www.sqlite.org/datatype3.html

And they have functions for manipulating time:

https://www.sqlite.org/lang_datefunc.html

A free service run by Zed A. Shaw for learncodethehardway.org.