Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Wrong date displayed when connecting Sybase from ODBC

Status
Not open for further replies.

synesis

Programmer
May 25, 2010
1
0
0
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top