Inserting into date datatype in mssql

[skima]

i wrote a script that dumps into mssql from mysql. it fetches the data then  create an insert query to insert into mssql. the problem am having now is that the date will always prompt  me that null values not accepted even though there is data to be inserted.

 

INSERT INTO asset ( assetcode , desc1 , type , purchdate , allocatedt , amount , modelno , regdno , make , status , comment , regdate , deptcode , allocate1 , regddate , accttype , accode , staffid , purdate , compcode) VALUES('AST56','555','555','08/01/2008','444','44','44','44','09/01/2008','555','555','02/01/2008','555',1,'01/08/2008',8.8,'888','777','09/01/2008','bssl');

 

i tried to unquote the date values but still same problem.

[tauchai83]

i guess the datetime you declare as the datatype should be 1st converted  to safe date string 1st. Only Date