Monday, April 6, 2009

Oracle Date/Time Stuff

Minutes between class begin/end time:
(to_date(a.END_TIME1, 'HH24:mi') - to_date(a.START_TIME1, 'HH24:mi'))*1440

Useful when attempting to find standard meeting pattern issues.

No comments:

Post a Comment