I need assistance with writing a query for the following criteria.
Any source of Construction created between 1am – 5:30am would be considered normal maintenance (non-outage).
Any source of Construction outside of those hours would be considered an outage.
I cant seem to add the time range properly. Any suggestions?
WHEN UPPER(SOURCE) = 'CONSTRUCTION'
AND UDF_CONVERT_UNIX_DATETIME(DATE_CREATED, 'US/Eastern')
BETWEEN TO_DATE('01:00:00','HH24:MI:SS') and TO_DATE('05:30:00','HH24:MI:SS') THEN 'MNT'
END) AS FORM_TYPE,