How can i actually detect the time as shown below?
If the user select the data from the database between 2008/06/05 12:00:00 and 2008/06/06 12:00:00 and the database type is varchar?
I can select that particular data out, but i need to further categorize it according to hours, like this:
If vDateTime.Hour >= 0 And vDateTime.Hour < 24 Then Dim hour As Integer = vDateTime.Hour If hour = 0 Then hour = 24 End If
but the 2PM at 2008/06/05 will crash with 2PM at 2008/06/06