Previous Topic: DatesNext Topic: Timestamps


Times

The external data representation of times can consist of any combination of its component parts, or derivatives of these parts, in any order, separated by any number of literals. Times are internally composed of three component parts, the 2-digit hour, 2-digit minute of the hour, and 2-digit second of the minute. Other components can be derived from these values, including a time zone name, 12-hour clock AM or PM specifier, and 24-hour clock hours.

The following table lists the default values for time edit patterns.

Component

Edit Pattern Picture Specifier

Default Value

2-digit Hour

HH

Zero

2-digit minutes of the hour

MM or MI

Zero

2-digit seconds of a minute

SS

Zero