Time Formats

Trang chủ » Hh Vs Hh » Time Formats

Có thể bạn quan tâm

You are here: Formats > Time 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

  • Time Functions
  • ICU Time Zones
  • Using the Time Zone Functions
  • TimeZone2TimeZone

© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.

Open table of contents

Open table of contents

Open table of contents

Từ khóa » Hh Vs Hh