In my previous post I logged some of my finding about Date vs. DateTime type. Here is another reason that Date type may cause problem.
In TABLE1 we have a StartDate which is a Date type. Through SLOX UI everything works fine – 00:00:00 is used as the time value when saving and SLOX knows not to do any conversion.
However there is a database view retrieving same field. It seems that SLOX doesn’t know the exact type of the field in the view so it does the UTC-to-local conversion. The result is that we get back a value which is 7/8 hours earlier.
I don’t know why SLOX provides different Date and DateTime type in table design. In SQL 2005 they are all DateTime. Maybe it saves spaces in other databases?