Is there any difference between DateTime in c# and DateTime in SQL server?

by

Precision and range (so, everything important ;-p)

From MSDN:

.NET System.DateTime

The DateTime value type represents dates and times with values ranging from 12:00:00 midnight, January 1, 0001 Anno Domini (Common Era) through 11:59:59 P.M., December 31, 9999 A.D. (C.E.)

Time values are measured in 100-nanosecond units called ticks, and a particular date is the number of ticks since 12:00 midnight, January 1, 0001 A.D. (C.E.) in the GregorianCalendar calenda

Transact SQL datetime

Date Range: January 1, 1753, through December 31, 9999

Accuracy: Rounded to increments of .000, .003, or .007 seconds

More Related Contents:

  1. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  2. Using DateTime in a SqlParameter for Stored Procedure, format error
  3. DateTime’s representation in milliseconds?
  4. How to get nullable DateTime out of the database
  5. Days between two dates in asp.net
  6. How do I calculate someone’s age based on a DateTime type birthday?
  7. How to pass an array into a SQL Server stored procedure
  8. Call a stored procedure with parameter in c#
  9. Execute a large SQL script (with GO commands)
  10. Calling stored procedure with return value
  11. Using StringWriter for XML Serialization
  12. Entity framework very slow to load for first time after every compilation
  13. How do I convert an ISO8601 TimeSpan to a C# TimeSpan?
  14. Why DateTime.AddHours doesn’t seem to work?
  15. How to convert Javascript datetime to C# datetime?
  16. How can I format a nullable DateTime with ToString()?
  17. Code to validate SQL Scripts
  18. What’s a good way to overwrite DateTime.Now during testing?
  19. Connection timeout for SQL server
  20. DateTime and CultureInfo
  21. Datetime in C# add days
  22. How do I get modified date from file in C# on Windows Mobile?
  23. How frequent is DateTime.Now updated ? or is there a more precise API to get the current time?
  24. What is passing parameters to SQL and why do I need it?
  25. How can i format 07/03/2012 to March 7th,2012 in c# [duplicate]
  26. Days, hours, minutes, seconds between two dates
  27. Is it better to execute many sql commands with one connection, or reconnect every time?
  28. SQL Server: Dynamic where-clause
  29. Add hours or minutes to the current time
  30. Convert string to datetime Using C#

Leave a Comment