[Mono-bugs] [Bug 69582][Wis] New - Wrong dates returned through SQL query

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Tue, 16 Nov 2004 19:27:18 -0500 (EST)


Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by scott.grosch@intel.com.

http://bugzilla.ximian.com/show_bug.cgi?id=69582

--- shadow/69582	2004-11-16 19:27:18.000000000 -0500
+++ shadow/69582.tmp.3587	2004-11-16 19:27:18.000000000 -0500
@@ -0,0 +1,50 @@
+Bug#: 69582
+Product: Mono: Runtime
+Version: unspecified
+OS: RHEL 2.1
+OS Details: 2.4.9-45lxset12smp 
+Status: NEW   
+Resolution: 
+Severity: Unknown
+Priority: Wishlist
+Component: misc
+AssignedTo: mono-bugs@ximian.com                            
+ReportedBy: Scott.Grosch@intel.com               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Wrong dates returned through SQL query
+
+Please fill in this template when reporting a bug, unless you know what 
+you are doing.
+Description of Problem:
+
+Using a call into the SQL server that returns a SmallDateTime object, I'm 
+getting incorrect results.  I've run the stored procedure via Microsoft's 
+SQL Query Analyzer and on UNIX via the FreeTDS libraries, both of which 
+return the date I expect.
+
+When I run my app on windows directly I also get the expected dates.  
+When I run via mono on my Linux box, I'm getting dates in the year 1825 
+instead of 2004 and 2005
+
+
+Steps to reproduce the problem:
+1. Create a connect, create a command object, call stored procedure
+2. Use a SqlDataReader and call reader.GetDateTime(1)
+3. Print the date
+
+Actual Results:
+
+06/03/1826
+
+Expected Results:
+
+11/7/2005
+
+How often does this happen? 
+
+Every time I make this call
+
+Additional Information: