Hi there,

i am storing a time in my table as a nvarchar(5) field. I used a this as i dont care about the date and just want the time. I dont know if this is a good idea or not.

but now i need to do a SELECT on the fields ScheduledArrivalTime and ActualArriveTime and compare them the time difference in Minutes.

How can i do this?

SELECT * FROM tbl_MyTable WHERE
ScheduledArrivalTime - ActualArriveTime > 60