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: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Friday, December 16, 2011 1:19 PM To: profoxt...@leafe.com Subject: Re: date handling in sql server 2005 express Thanks for the info Rafael _______________________________________________ Post Messages to: ProFox@leafe.com 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.
