Hi all, I have a question related to data type when defining a new table. When I define my table, I realise that we define the attribute "DOB" as DATE, but when I want to enter data into my table, as follows: e.g. INSERT INTO Branch(DOB) VALUES ('1995-10-31') The value I inserted into the table is a string, so when I did additional test to see whether this data is automatically transformed to DATE data type, I encountered an unexpected result. There are some solutions I came up with after research: 1. Use DATE() --> INSERT INTO Branch(DOB) VALUES (DATE '1995-10-31'): the expected result is not 1995-10-31 2. According to the textbook, numeric data should be in a quotation mark --> INSERT INTO Branch(DOB) VALUES (1995-10-31): SQL does the subtraction. Can anyone help me on this problem? Thank you so much.