create table EMPLOYEE (
    FNAME varchar(20) NOT NULL,
    MINIT varchar(1) NOT NULL,
    LNAME varchar(20) NOT NULL,
    SSN varchar(9) primary key,    
    BDATE date NOT NULL,
    CITY varchar(15) NOT NULL,
    SEX varchar(1) NOT NULL,
    SALARY int NOT NULL, 
    SUPERSSN varchar(9),
    DNO varchar(1),
)

insert into EMPLOYEE values ('John','B','Smith','123456789',1965-09-01,'Houston','M',30000,'333444555','5');

When i try to execute the above code it says

Server: Msg 2715, Level 16, State 7, Line 4
Column or parameter #5: Cannot find data type date.

Please help me with this.

Thanks

You need to put your date in quotes when inserting. I'm assuming you're using the MySql database engine.

Thanks
I've change the "date" datatype with "datetime"
it was a syntax error.

Always specify the DB or the Language in which you facing the problem.