We created metadata for a database and for some reason, the ...

[Toby Mills]

Cool deal Diana

If you get a chance, please let us know what was going on there when you get to the bottom of it.

Its an interesting case.

I need more hobbies I think

Toby

[Debra Waybright]

Ah, Webfocus. Always keeping us on our toes! Im looking forward to learning what is causing this and what the fix is. (And hoping I dont run into it! )

[Diana Watkins]

OK, so we were able to get it fixed and MAY have figured out WHY it was happening (although havent truly tested the resolution to the WHY as of yet)

SOOO after some digging on the internet, we found where several others had had the same issue of subtracting 2 days from a date field. The issue appeared to be with the jdbc driver that WF was using having some issues with date, datetime2, and timeoffset field types in SQL Server. The issue was reported to be with jdbc3/4 and resolved with jdbc42 (according to posts from stack exchange, stack overflow, etc).

While researching the jdbc setting in WF, the vendor we were working with changed the offending dates in the db to a Datetime format and the issue resolved itself. So we didnt get a chance to change the jdbc driver and test that theory out but we will try in the future. We have an upgrade coming up so the new jdbc driver may be in place then anyway.

So the issue is resolved for now, and we have homework to do later to make sure it doesnt bite us as we bring on new databases in the future.

[Toby Mills]

Thanks for the update on this Diana - I havent ever seen that. Now we all know.

Just in case it speeds anybody up in the future. this is probably the Stackoverflow thread:

Java JDBC: dates consistently two days off

Thanks again for taking the time to come back and fill us in!