SQL: smalldatetime and year 1899
Posted on 2013-05-10
I have a situation that involves Visual FoxPro, ODBC in middle and SQL 2008 on the other side of the table.
The ODBC apparently converts 'blank' dates coming from FoxPro to '1899-12-30' and trying to write that to SQL's SmallDatetime data type field.
Does anyone have a trigger code for that for the SQL side to alter the date to something else, something acceptable such as '1900-01-01'?
Thank you for your help in advance.
PS: ultimately I will have to perform this action on 300+ columns in a table-set.