The TIME data type is used to represent the hour (hh), minute (mm) and second (ss). Supported range is "00:00:00" to "23:59:59." Second can be omitted; if it is, 0 seconds is specified. Both 12-hour and 24-hour notations are allowed as an input format.
The input format of TIME is as follows:
'hh:mi [:ss] [am | pm]'
TIME '00:00:00’ is outputted as '12:00:00 AM'.
TIME '1:15' is regarded as '01:15:00 AM'.
TIME '13:15:45' is regarded as '01:15:45 PM'.
TIME '13:15:45 pm' is stored normally.
TIME '13:15:45 am' is an error (an input value does not match the AM/PM format).