converting mysql datetime in vb.net

Asked Jan 06 '15 at 14:10

Active Jan 06 '15 at 14:11

Viewed 28 times

I am using this code in my vb.net app:

If reader3.GetString(6).ToString = "0000-00-00" Then
    product_detail_from_date = ""
Else
    product_detail_from_date = Convert.ToDateTime(reader3.GetString(6)).ToString("dd/MM/yyyy")
End If

on this occasion, reader3.getstring(6) does equal 0000-00-00

Unable to convert MySQL date/time value to System.DateTime

how can i stop this error showing and get the code working with the IF statement?

edited Jan 06 '15 at 14:11

Ňɏssa Pøngjǣrdenlarp

38,411
12
59
178

asked Jan 06 '15 at 14:10

charlie

what is the column type, string/text or date? – Ňɏssa Pøngjǣrdenlarp Jan 06 '15 at 14:12
2

Why do you store datetimes as string? – Tim Schmelter Jan 06 '15 at 14:14
they are not as string – charlie Jan 06 '15 at 14:34

converting mysql datetime in vb.net

0 Answers0