How to save leap date ’02/29/2006′ to sql server database? [duplicate]

by

Maybe it’s because it’s not a leap year? 🙂

2006 is not a leap year. Leap years occur usually every four years (those years whose number is divisible by four) except for century years (divisible by 100) whose number is not divisible by 400. 2006 is not divisible by 4, so it fails the first condition.

More Related Contents:

  1. How do I update a value in C# and SQL Server? [closed]
  2. Error: You have an error in your SQL syntax – but SQL statement works
  3. Store value in Yes/No field in Access using C#
  4. Fastest Way of Inserting in Entity Framework
  5. Execute Insert command and return inserted Id in Sql
  6. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
  7. Adding multiple parameterized variables to a database in c#
  8. C# SQL Server – Passing a list to a stored procedure
  9. linq case statement
  10. Difference between Parameters.Add(string, object) and Parameters.AddWithValue
  11. How do I connect to an MDF database file?
  12. SQL injection on INSERT
  13. SQL WHERE clause matching values with trailing spaces
  14. Equivalent of SQL ISNULL in LINQ?
  15. SqlBulkCopy from a List
  16. How to fill Dataset with multiple tables?
  17. The C# using statement, SQL, and SqlConnection
  18. C# constructing parameter query SQL – LIKE %
  19. Generate class from database table
  20. Passing a SQL parameter to an IN() clause using typed datasets in .NET
  21. What is passing parameters to SQL and why do I need it?
  22. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  23. Calling a SQL User-defined function in a LINQ query
  24. How to create NVarchar(max) Sqlparameter in C#? [duplicate]
  25. Enabling Foreign key constraints in SQLite
  26. no overload for method “ToString” takes 1 arguments
  27. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  28. Querying data using Entity Framework from dynamically created table
  29. Microsoft.Jet.OLEDB.4.0 Converting Characters
  30. SQL connection string for microsoft access 2010 .accdb

Leave a Comment