difference in data between sync. script and database source
Gwen
Posts: 2
Hi,
I made a synchronisation script for my database.
In a table I have a "datetimeoffset(7)" Field with the value : '2011-05-31 23:59:59.0000000 -04:00'
but in the script, this field is set to : '2011-06-00 23:59:59.0000000 -04:00'
and that throw an error because the June 0 does not exist.
Could anyone help me ?
Thanks
I made a synchronisation script for my database.
In a table I have a "datetimeoffset(7)" Field with the value : '2011-05-31 23:59:59.0000000 -04:00'
but in the script, this field is set to : '2011-06-00 23:59:59.0000000 -04:00'
and that throw an error because the June 0 does not exist.
Could anyone help me ?
Thanks
Gwen
Comments
Unfortunately it looks like you've hit a bug in the software. This was reported recently by another customer, and we have it logged internally as ref SDC-1239.
Unfortunately there's no fix available just yet, but I've linked this forum post on the bug so we know someone else has hit it.
It seems to be caused by the way the values are handled internally, so you'll only encounter the issue where the value falls within such a range where the offset pushes it into the "next day".
Redgate Software