http://www.devx.com/tips/Tip/13898

"Values for datetime data types earlier than January 1, 1753 are not
permitted in SQL Server. SQL Server rejects all values that do not
fall within the range from 1753 to 9999.

Another SQL Server data type, smalldatetime, stores dates and times of
day with less precision than datetime datatype. Valid date range for
this data type is from January 1, 1900 through June 6, 2079."

-Cameron

On Tue, 28 Dec 2004 14:23:57 -0800, Bryan Stevenson
<[EMAIL PROTECTED]> wrote:
> hmmm...after some quick testing...it looks like it goes back to 1754 if
> anyone cares ;-)
> 
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
> 
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188910
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to