Convert DateTime for MySQL using C#

by

Keep in mind that you can hard-code ISO format

string formatForMySql = dateValue.ToString("yyyy-MM-dd HH:mm:ss");

or use next:

// just to shorten the code
var isoDateTimeFormat = CultureInfo.InvariantCulture.DateTimeFormat;

// "1976-04-12T22:10:00"
dateValue.ToString(isoDateTimeFormat.SortableDateTimePattern); 

// "1976-04-12 22:10:00Z"    
dateValue.ToString(isoDateTimeFormat.UniversalSortableDateTimePattern)

and so on

More Related Contents:

  1. How do I calculate someone’s age based on a DateTime type birthday?
  2. DateTime vs DateTimeOffset
  3. Parse DateTime with time zone of form PST/CEST/UTC/etc
  4. String was not recognized as a valid DateTime ” format dd/MM/yyyy”
  5. C# DateTime.Now precision
  6. format date in c#
  7. How do I get the last day of a month?
  8. What does “DateTime?” mean in C#?
  9. Get Month name from month number
  10. Environment.TickCount vs DateTime.Now
  11. ASP.NET use SqlConnection connect MySQL
  12. How do I represent a time only value in .NET?
  13. Why DateTime.AddHours doesn’t seem to work?
  14. Parse C# string to DateTime
  15. DateTime ToString issue with formatting months with “mm” specifier
  16. How do I get the AM/PM value from a DateTime?
  17. How to ensure a timestamp is always unique?
  18. How can I format DateTime to web UTC format?
  19. How frequent is DateTime.Now updated ? or is there a more precise API to get the current time?
  20. Convert String to Date in .NET if my incoming date format is in YYYYMMDD
  21. How to parse and generate DateTime objects in ISO 8601 format
  22. DateTime conversion from string C#
  23. Get affected rows on ExecuteNonQuery
  24. Getting the first and last day of a month, using a given DateTime object
  25. Days, hours, minutes, seconds between two dates
  26. How to pass a table as parameter to MySqlCommand?
  27. Convert Date from Persian to Gregorian
  28. Unix time conversions in C# [duplicate]
  29. Could not load file or assembly ‘MySql.Data, Version=6.2.2.0
  30. .NET: Why is TryParseExact failing on Hmm and Hmmss?

Leave a Comment