Another thing you can do is avoid building date/datetime values by using the date() or datetime() functions like this:
DATE([nYear, nMonth, nDay]) DATETIME([nYear, nMonth, nDay [, nHours [, nMinutes [, nSeconds]]]]) Then there's no amibiguity about what portion of the date is in what position. -- rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rafael Copquin Sent: Friday, December 16, 2011 1:19 PM To: [email protected] Subject: Re: date handling in sql server 2005 express Thanks for the info Rafael _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD0441D4A354148@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
