Stefan_G (4/17/2010)

---

You should also consider permanently changing the datatype of this column to datetime, or perhaps time.

kjkeyan (4/18/2010)

---

HI,
Thanks for your suggestion ,but i have tried this query

SELECT StartTime
FROM TicketTransaction
WHERE
convert(datetime,StartTime) <= '12:30 PM'
AND
convert(datetime,StartTime) >= '05:30 PM'

Its not working and i am getting an error
'Conversion failed when converting datetime from character string'

And i have tried this query


SELECT convert(datetime, StartTime, 109)
FROM TicketTransaction
WHERE
StartTime <= '12:30 PM'
AND
StartTime >= '05:30 PM'

Its giving the output but not exact record .

SELECT MAX(convert(datetime, StartTime, 109))
FROM TicketTransaction

SELECT *
FROM TicketTransaction
WHERE ISDATE(StartTime) = 0