Data Vault Administrator Guide

Back Next

Time Picture Components

The following tables define the components of the Time Picture parameter.

Hour: The following table describes the Hour component of the Time Picture parameter:

Column

Description

h

An integer between 0 and 23 (inclusive), corresponding to the hour of the day; does not display leading zeros

hh

An integer between 00 and 23 (inclusive), corresponding to the hour of the day; displays leading zeros
Minute: The following table describes the Minute component of the Time Picture parameter:

Column

Description

m

An integer between 0 and 59 (inclusive), corresponding to a number of minutes; does not display leading zeros

mm

An integer between 00 and 59 (inclusive), corresponding to a number of minutes; displays leading zeros
Second: The following table describes the Second component of the Time Picture parameter:

Column

Description

s

An integer between 0 and 59 (inclusive), corresponding to a number of seconds; does not display leading zeros

ss

An integer between 00 and 59 (inclusive), corresponding to a number of seconds; displays leading zeros

The following examples show time format masks and the resulting output, using the time 15:08:25.

Time Picture for 12-hour Clock

Displayed Date

hh:mm:ss am 12

03:08:25 pm

hh.mm 12

03.08

AM h-m-s 12

PM 3-8-25

Time Picture for 24-hour Clock

Displayed Date

hh:mm:ss 24

15:08:25

hh.mm 24

15.08

h-m-s 24

15-8-25

Column	Description
h	An integer between 0 and 23 (inclusive), corresponding to the hour of the day; does not display leading zeros
hh	An integer between 00 and 23 (inclusive), corresponding to the hour of the day; displays leading zeros

Column	Description
m	An integer between 0 and 59 (inclusive), corresponding to a number of minutes; does not display leading zeros
mm	An integer between 00 and 59 (inclusive), corresponding to a number of minutes; displays leading zeros