Data Vault Administrator Guide

6.5 HotFix 1
- 6.5.1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Date Picture Components

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

Day: The following table describes the Day component of the Date Picture parameter:

Column
Description

d
Integer between 1 and 31, corresponding to day of month; leading zeros are not displayed.

dd
Integer between 01 and 31, corresponding to day of month; leading zeros are displayed.

ddd
Integer between 1 and 365 (366 in a leap year), corresponding to number of days since first of the year; leading zeros are not displayed.
Month: The following table describes the Month component of the Date Picture parameter:

Column
Description

m
Integer between 1 and 12, corresponding to a month; leading zeros are not displayed

mm
Integer between 01 and 12, corresponding to a month; leading zeros are displayed

mmm
A three-character abbreviation for the month corresponding to the stored month number (for example: JAN, FEB, MAR, and so on)

mmmm
Month name corresponding to the stored month number (for example: January, February, March, and so on)
Year: The following table describes the Year component of the Date Picture parameter:

Column
Description

yy
Last two digits of stored year

yyyy
Entirety of stored year
Weekday: The following table describes the Weekday component of the Date Picture parameter:

Column
Description

ww
An integer corresponding to the day of week (Monday=1, Tuesday=2, Wednesday=3, and so on)

www
Three-character abbreviation for the day of the week (for example, MON, TUE,WED, and so on)

wwww
The day of the week on which a date falls (for example, Monday, Tuesday, Wednesday, and so on)

The following examples show some date pictures using the date August 31, 2002:

Date Picture
Displayed Date

m/d/yy
8/31/02

mm/dd/yy
08/31/02

mm/dd/yyyy
08/31/2002

dd-mm-yy
31-08-02

yyyy-mm-dd
2002-08-31

mmm-dd-yyyy
AUG-31-2002

mmddyyyy
08312002

mmmm,yyyy
August,2002

Column	Description
d	Integer between 1 and 31, corresponding to day of month; leading zeros are not displayed.
dd	Integer between 01 and 31, corresponding to day of month; leading zeros are displayed.
ddd	Integer between 1 and 365 (366 in a leap year), corresponding to number of days since first of the year; leading zeros are not displayed.

Column	Description
m	Integer between 1 and 12, corresponding to a month; leading zeros are not displayed
mm	Integer between 01 and 12, corresponding to a month; leading zeros are displayed
mmm	A three-character abbreviation for the month corresponding to the stored month number (for example: JAN, FEB, MAR, and so on)
mmmm	Month name corresponding to the stored month number (for example: January, February, March, and so on)

Column	Description
ww	An integer corresponding to the day of week (Monday=1, Tuesday=2, Wednesday=3, and so on)
www	Three-character abbreviation for the day of the week (for example, MON, TUE,WED, and so on)
wwww	The day of the week on which a date falls (for example, Monday, Tuesday, Wednesday, and so on)

Date Picture	Displayed Date
m/d/yy	8/31/02
mm/dd/yy	08/31/02
mm/dd/yyyy	08/31/2002
dd-mm-yy	31-08-02
yyyy-mm-dd	2002-08-31
mmm-dd-yyyy	AUG-31-2002
mmddyyyy	08312002
mmmm,yyyy	August,2002

Column	Description
yy	Last two digits of stored year
yyyy	Entirety of stored year

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

Date Picture Components

Date Picture Components