Ted, Apologies on that, it is SmallDateTime that has been deprecated in SQL 2012. However the approved and suggested advice is to actually use DateTime everywhere as Date will at some time always go the same way.
Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Ted Roche Sent: 22 August 2013 16:59 To: [email protected] Subject: Re: [NF] smalldatetime default value function On Thu, Aug 22, 2013 at 10:24 AM, Dave Crozier <[email protected]> wrote: > Andy, > The date field in SQL is to be deprecated and all dates should be held > in DateTime format. Are you referring to Microsoft/Sybase SQL Server, MySQL, or all SQL engines based on the SQL Standard, such as it is? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- 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://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
