SQL - Time Query

[simran1]

Hi,

I have this Query
SQl = "Select * from IncidentReport Where ITime = '8:58:00 AM'"

And i have a record to match the comparison. But i still get the record count to be Zero.
How do i do time comparisons?

 

[JayKusch]

Try ...

Select * from IncidentReport Where
Convert(Char(12), ITime,108) = '8:58:00 AM' Thanks

J. Kusch

 

[simran1]

Hi,
Am sorry, but i still get my record count to be zero.

 

[SQLBill]

Do you have to query using the AM/PM time format? Can you use the 24 hour format?

Using 108 with CONVERT returns the time as hh:mm:ss (24 hour format).

If you can use that format, try this:

Select * from IncidentReport Where
Convert(Char(12), ITime,108) = '08:58:00'

-SQLBill