Go for Date datatype if you're using SQL Server 2008. It was a PITA to get the date part out of the Datetime field in previous versions, especially when working with date intervals. (If the user enters 2010/06/26 in the textbox, the server stores it as 2010/06/26 00:00:00, which is smaller than any other value in the same day. And if you need all the records containing values in range 2010/06/01 - 2010/06/26, you could not use BETWEEN, but had to resort to an expression like this: Where OrderDate >= '2010/06/01' And OrderDate < '2010/06/27')
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ajoy Khaund Sent: Saturday, June 26, 2010 6:13 PM To: [email protected] Subject: Sqlserver 2005 or 2008 Hi, I did some testing in sqlserver in dec 2009 and am finding some time again to look into it as a backend. Since I am starting new should I go for sqlserver 2008 ? How are you all keeping a date field like birthdate or hiredate in 2005. Are you all keeping it in text format or smalldatetime ? I saw somewhere the version 2008 has a date field. Thanks for any advice. -- Regards, Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785001-21 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: [email protected] Mail: [email protected] http://teaanalyst.blogspot.com/ "Walking on water and developing software from a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ 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/[email protected] ** 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.
