help! A bug about date type !# Database - 数据库
d*i
1 楼
Do not why is not work?
maybe date type is wrong.
literal does not match format string
drop table employee;
create table employee( FNAME varchar(15),
MINIT char,
LNAME varchar(15),
SSN char(9),
BDATE date,
ADDRESS varchar(30),
SEX char,
SALARY decimal(10,2),
SUPERSSN char(9),
DNO int
);
insert into employee values('john','B','Smith','123456789',
'1956-11-11',
'731 Fondren, Houston,TX', 'M',
30000,'333445555',5);
maybe date type is wrong.
literal does not match format string
drop table employee;
create table employee( FNAME varchar(15),
MINIT char,
LNAME varchar(15),
SSN char(9),
BDATE date,
ADDRESS varchar(30),
SEX char,
SALARY decimal(10,2),
SUPERSSN char(9),
DNO int
);
insert into employee values('john','B','Smith','123456789',
'1956-11-11',
'731 Fondren, Houston,TX', 'M',
30000,'333445555',5);
