Environment: DS 4.2 SP12; MS SQL Server 2016 (both on Windows server 2016)
I’m trying to write a datetime field into a MS SQL Server 2016 table, whose column is declared as DATETIME2.
Whenever I have a date Beyond June 6th 2079 it bounces me the following error:
: <[Microsoft][ODBC SQL Server Driver]Fractional truncation Datetime field overflow>.
Indeed this is quite strange! As June 6th 2079 is the upper limit for SMALLDATETIME type (DATETIME2 goeas as far as December 31st 9999).
I spent all the day trying to work out where and how to understand how to get rid of this, but all I found is that there is a default parameter that is taken at SQLExecute time (“0” instead of the expected “7”), but I did not find a way to put it in place.
Did any of you run into this before, and found how to go through?
Thank you in advance
Claudio
CLS69 (BOB member since 2009-06-11)