.NET DateTime to SqlDateTime Conversion

by

Is it possible that the date could actually be outside that range? Does it come from user input? If the answer to either of these questions is yes, then you should always check – otherwise you’re leaving your application prone to error.

You can format your date for inclusion in an SQL statement rather easily:

var sqlFormattedDate = myDateTime.Date.ToString("yyyy-MM-dd HH:mm:ss");

More Related Contents:

  1. How do I calculate someone’s age based on a DateTime type birthday?
  2. Parse string to DateTime in C#
  3. Creating a DateTime in a specific Time Zone in c#
  4. How to truncate milliseconds off of a .NET DateTime
  5. C# DateTime.Now precision
  6. format date in c#
  7. calculating the difference in months between two dates
  8. How to get client date and time in ASP.NET?
  9. What does “DateTime?” mean in C#?
  10. Format a date in XML via XSLT
  11. How to compare DateTime in C#?
  12. Environment.TickCount vs DateTime.Now
  13. Why DateTime.AddHours doesn’t seem to work?
  14. Convert DateTime for MySQL using C#
  15. How to convert Javascript datetime to C# datetime?
  16. How to find the 3rd Friday in a month with C#?
  17. How does DateTime.ToUniversalTime() work?
  18. Convert DateTime to Julian Date in C# (ToOADate Safe?)
  19. Difference between System.DateTime.Now and System.DateTime.Today
  20. why does DateTime.ToString(“dd/MM/yyyy”) give me dd-MM-yyyy?
  21. How to ensure a timestamp is always unique?
  22. How can I format DateTime to web UTC format?
  23. datetime to string with time zone
  24. How frequent is DateTime.Now updated ? or is there a more precise API to get the current time?
  25. Getting the first and last day of a month, using a given DateTime object
  26. Days, hours, minutes, seconds between two dates
  27. How to check if a DateTime occurs today?
  28. Convert Date from Persian to Gregorian
  29. Unix time conversions in C# [duplicate]
  30. .NET: Why is TryParseExact failing on Hmm and Hmmss?

Leave a Comment