Times can be entered in several formats. The time formats are explained in this table:
| Format | Time Segments | Description | 
| 1 | HH:MM:SS | Time is based on a 24 hour system. This is frequently referred to as "military time". The 24 hour system is the default format. Example: 14:18:23 | 
| 2 | HH:MM:SS XM | Time is based on a 12 hour system. AM or PM is given. Example: 02:18:23 PM | 
| 3 | HH:MM | Time is based on a 24 hour system. Seconds are not given. Example: 14:18 | 
| 4 | HH:MM XM | Time is based on a 12 hour system. Seconds are not given. AM or PM is given. Example: 02:18 PM | 
The separators you can use include:
'.' = 99.99.99 ',' = 99,99,99 '-' = 99-99-99
'b' = 99 99 99 ':' = 99:99:99 (default)
© Copyright 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices