'SQL DATE syntax or usage

i have a problem with the date syntax and i get this error: 'Operand type clash: int is incompatible with date' I have tried inserting this values in the table like this: '19990531' , '1999-05-31' , 1999-05-31 , 31-05-1999. So I can not see other ways to do this. Can someone help!

My code:

CREATE TABLE [Customer] (
Cus_id integer NOT NULL IDENTITY (1,1),
Adress_id integer NOT NULL,
First_name text NOT NULL,
Last_name text NOT NULL,
Birthdate date NOT NULL,
Phone integer NOT NULL UNIQUE,
Email binary NOT NULL UNIQUE,
Password binary NOT NULL,
signup_time timestamp NOT NULL
sqlsql-serversyntax


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions