Insert date value into SQL Server datetime columm

chulett · Post by **chulett** » Tue Mar 03, 2009 7:51 pm

Well... as least we're finally at a Resolved status. Thanks for your perseverance, hopefully anyone stumbling across this same issue in SQL Server will make it all the way to the end and save themselves a lot of time.

I've stashed this away in my Favorites on the off-chance I have the... pleasure... of working with that particular database.

deployDS · Post by **deployDS** » Fri Dec 18, 2009 8:40 am

Here is the way I did it with ODBC Stage.

Change Datatype to VARCHAR and append the time part to it and load it as VARCHAR for insert/update and it should work.

This post was really helpful, thanks to all of you