Skip to Content.
Sympa Menu

freetds - GETDATE() Problems with MSSQL7-SP2 and Freetds 0.51 and Solaris

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZULU" <urbas AT nulleins.at>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: GETDATE() Problems with MSSQL7-SP2 and Freetds 0.51 and Solaris
  • Date: Thu, 1 Feb 2001 11:24:27 -0500


hi

On our developmentmachine we are using linux - there all SQL statements
work fine. Our client machine is an
SunOS 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-4 this is the only
known difference.
The porblems occures in all date related SQL funtions, I dont know if
Insert statements work fine but the select statements equal on rows or on
integrated functions like getdate or Current_timestamp produce no valid
days.

Datetime fields returns always Feb 07 2036 06:30A.
Getdate and Current_timestamp return an date between 1900 and 2036 -
growing all time to the maximum and starts again

Hm
Hope somebody finds an answer.

mfg Gerald Urbas




Archive powered by MHonArc 2.6.24.

Top of Page