create table testdb(accid varchar(22),occmonth date ,debitoccur float); insert into testdb values('101','2013-1-2',14.3);