how to insert date in sql server as 31-12-9999.

Question

Sir Pls. suggest that how to insert 31-12-9999 date in sql server

Vulpes · Answer

As you can see from this table most of the date/time types in SQL Server can accommodate dates up to and including 31-12-9999: http://msdn.microsoft.com/en-gb/library/ms186724.aspx I've always found personally that you have least problems with dates (different cultures etc) if you insert them in the format yyyy-MM-dd. So this should work: DateTime dt = new DateTime(9999 12 31); and then use: ' + dt.ToString(yyyy-MM-dd) + ' in your INSERT command or better still use a parameter so you don't have to worry about this stuff.

Monika Singh · Answer

Thanku sir.

Joginder Banger · Answer

what type of working this date plz share more information whats you try if you just store in table direct pass with in string ' 31-12-9999'