Set Date to 1753-01-01 00:00:00.000 RSS

• • Reply
  

  lesponce

  Member

  108 Points

  313 Posts

  Set Date to 1753-01-01 00:00:00.000

  Nov 15, 2012 05:24 PM|LINK

  How do you pass a date parameter with value '1753-01-01 00:00:00.000' to a stored procedure using C#?

  I tried DateTime.MinValue, but that doesn't work.

   

• • Reply
  

  Curt_C

  All-Star

  66017 Points

  7639 Posts

  Moderator

  Re: Set Date to 1753-01-01 00:00:00.000

  Nov 15, 2012 05:26 PM|LINK

  That isn't DateTime.MinValue, that's why.

  Just pass it as a string, SQL should interpret it fine.

  Have you read the book? - ASP.Net 3.5 CMS Development (now on Kindle)
  v5.1 of iTracker (Inventory Tracker Starter Kit) is out, Download it now!
• • Reply
  

  lesponce

  Member

  108 Points

  313 Posts

  Re: Set Date to 1753-01-01 00:00:00.000

  Nov 15, 2012 05:29 PM|LINK

  I know, I tried MinValue and when the program calls the SP, I get:

  SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

• • Reply
  

  lesponce

  Member

  108 Points

  313 Posts

  Re: Set Date to 1753-01-01 00:00:00.000

  Nov 15, 2012 06:25 PM|LINK

  This worked:

  DateTime.MinValue.AddYears(+1752)

  • Marked as answer by lesponce on Nov 15, 2012 06:25 PM
• • Reply
  

  Curt_C

  All-Star

  66017 Points

  7639 Posts

  Moderator

  Re: Set Date to 1753-01-01 00:00:00.000

  Nov 15, 2012 07:29 PM|LINK

  You're using .NET Datetime, use SQLDateTime instead

  instead of:
  DateTime.MinValue

  Use:
  System.Data.SqlTypes.SqlDateTime.MinValue

  Have you read the book? - ASP.Net 3.5 CMS Development (now on Kindle)
  v5.1 of iTracker (Inventory Tracker Starter Kit) is out, Download it now!