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

Monika Singh

Sir,

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Daril4y ago
Unless you are inserting it as a string the date is not formatted, that is the internal representation has no notion of 'format'.
```
DateTime xx = DateTime.Now;
        string change = "dd-mm-yyyy";
        string insert = xx.ToString(change);
```
Monika Singh12y ago
Thanku sir.
Vulpes12y ago
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.
Joginder Banger12y ago
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'