I am studying SQL Language and am having some problems in creating tables, I can not set a default value in a column, whenever I apply it indicates a syntax error. Can someone help me? I have no idea what is happening ... (If there are more errors and you can indicate, please, thank)
CREATE TABLE USUARIO
(
ID NUMERIC IDENTITY,
LOGIN VARCHAR(25) UNIQUE NOT NULL,
SENHA VARCHAR(15) NOT NULL,
DTEXPIRACAO DATE NOT NULL,
CONSTRAINT DF_DTEXPIRACAO DEFAULT(1900/01/01) FOR DTEXPIRACAO,
CONSTRAINT PK_USUARIO PRIMARY KEY (ID)
);