VB.NET how to convert a string into time

Question

Ive been having some trouble with this for a while. I want to be able to retrieve values of time stored in my database (as type time). I've tried:

reader.getDateTime("open_hours")

I just get an error. I've also tried converting the string into time but i can only convert it into datetime, meaning that i have the date as well as the time. How can i get just the time (in 24 hour format)?

the `GetDateTime` function already returns a DateTime object, so *Mission Accomplished*. No idea what `I just get an error` means — Ňɏssa Pøngjǣrdenlarp, Mar 07 '15 at 13:00
The error is 'Unable to convert MYSQL date/time value to system.datetime' — aLeXaNdRa08, Mar 07 '15 at 13:25
I tired adding Convert Zero Datetime=True to my connection string but now all iget from the reader is 00:00:00 — aLeXaNdRa08, Mar 07 '15 at 14:51

score 3 · Answer 1 · answered Mar 07 '15 at 12:20

3

you can use this link

for example:-

Dim strTime As String = "3:00 PM"

' Convert to datetime

Dim dtTime As DateTime = Convert.ToDateTime(strTime)
' Display in 24hr format

Response.Write(dtTime.ToString("HH:mm"))

example2:-

string militaryTime;
string originalTime = "3:11 PM";
DateTime dt;
if (DateTime.TryParse(originalTime, out dt))
    militaryTime = dt.ToString("HH:mm");

answered Mar 07 '15 at 12:20

Pradnya Bolli

1,915
1
19
37

The thing is, is need the it as a datetime, not a string, so that i can compare times. – aLeXaNdRa08 Mar 07 '15 at 13:23
nice one, this is what i've been looking for – jdwee Feb 05 '17 at 17:56

VB.NET how to convert a string into time

1 Answers1