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