TIME

Description

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]'

Remark
Example

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).