Hi,
I am developing anapplication in c# and silverlight.
My backend DB is Syabse and I establish connection vis ODBC.
When I fetch records for a particular year -1991,The fetch date is a hour earlier.
(i.e)
Say I have a table 1 and acolumn Date 1.The value in Date 1 is 3/31/1991 12:00 AM.The date returned is 3/30/1991 11:00 PM.
I cannot replicate this behaviour in Anywhere interactive SQL nor in Access DB.
I have also tried using Native ODBC driver but the same problem persist.
Note:The date from 3/11/1991-4/7/1991 only display wrong date.
Other dates are fetched correctly.
Any Idea what is causing this? and how this can be resolved?
I am developing anapplication in c# and silverlight.
My backend DB is Syabse and I establish connection vis ODBC.
When I fetch records for a particular year -1991,The fetch date is a hour earlier.
(i.e)
Say I have a table 1 and acolumn Date 1.The value in Date 1 is 3/31/1991 12:00 AM.The date returned is 3/30/1991 11:00 PM.
I cannot replicate this behaviour in Anywhere interactive SQL nor in Access DB.
I have also tried using Native ODBC driver but the same problem persist.
Note:The date from 3/11/1991-4/7/1991 only display wrong date.
Other dates are fetched correctly.
Any Idea what is causing this? and how this can be resolved?