Search results
If your string format for the DateTime is fixed you can convert to the System.DateTime using: string myDate = "12-Apr-1976 22:10"; DateTime dateValue = DateTime.Parse(myDate); Now, when you need it in your specific format, you can then reverse the process, i.e.: string formatForMySql = dateValue.ToString("yyyy-MM-dd HH:mm"); edit - updated code.
5 maj 2011 · It seems superfluous to convert it to a string and parse it as a datetime and this may introduce problems with enexpected date formats. If you have a Datetime in the database you could also do. txtEventDate.Text = Reader.GetDatetime(7).ToShortDateString();
11 kwi 2015 · If you're having 00-00-0000 date value stored, (Which is special zero value [^]; or you can say DateTime's NULL value), then you should know that .NET framework's DateTime object has a limitation over the DateTime value too, this might be the reason for your errors.
Fixed in 0.48.2. Note that calling MySqlDataReader.GetDateTime () when AllowZeroDateTime=True is potentially a bad idea anyway, as the column can contain values (such as 0000-00-00) that aren't expressible as a System.DateTime value. You may wish to write instead:
Restore (round-trip) a date and time value created by a formatting operation. Pass the "o" or "r" standard format string to the ToString (String) method, and call the Parse (String, IFormatProvider, DateTimeStyles) overload with DateTimeStyles.RoundtripKind.
11 cze 2010 · There is no Convert.ToDateTime or DateTime.Parse issue, because it looks like the the entity model itself has problem reading the field. I even can't ToString() it to a string-class-field. How do I came around this?
7 kwi 2023 · SQL date strings can be handed with DateTime.Parse. This is useful when you have database text-only data. DateTime.Parse works on the date time format in the MySQL database.
