You are here: Formats > Time Formats
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)
See Also
© Copyright 2015, Oracle and/or its affiliates. All rights reserved. Legal notices.