Error converting data type DBTYPE_DBTIMESTAMP to datetime.

[skystar]

Hi,
I would like to migrate an oledb database to sql 2005 database
While converting i got "Error converting data type DBTYPE_DBTIMESTAMP to datetime."
I have severl colones that i need to convert them to datetime at the same time in the same querry.

To begin i hve tried this but it's not working :

select date_clotu FROM OPENROWSET(
   'MSDASQL',
   'Driver={Microsoft dBase Driver (*.dbf)};DBQ=C:\Documents and Settings\oledb',
   'Select TO_CHAR(date_clotu) FormattedDate  from SQDI')where isdate(FormattedDate)=0 ;

Can u help me plz ...