I’m trying to build one database.
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’,
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.