I need to test if time1 is >= time2 where both times are hours and minutes only (24 hour clock).
eg: 13:02
A simple string comparison which works with other languages is giving me an error so it looks like I have to treat the strings as times not strings.
What is the best fuction to use in this situation?
Edit: To further complicate this I have to treat 1am to 3am as 25:00 to 27:00 because in transit databases they are considered part of the previous day since schedules for Saturday can be different than friday for instance. So really I need some sort of string comparison since date/time functions would not like my extended day times.
eg: 13:02
A simple string comparison which works with other languages is giving me an error so it looks like I have to treat the strings as times not strings.
What is the best fuction to use in this situation?
Edit: To further complicate this I have to treat 1am to 3am as 25:00 to 27:00 because in transit databases they are considered part of the previous day since schedules for Saturday can be different than friday for instance. So really I need some sort of string comparison since date/time functions would not like my extended day times.
Last edited:
