Display Formats for Date and Time Data

Display formats for date and time data typically apply a pattern to the data. For example, you can indicate whether you want a short form of the date or a long form, and whether to use space, slashes, or dashes as separators.

If you want to automatically apply the correct names of months and days, and the correct format for a specific locale, you can use the $NLS_LOCALE assignment setting or $nlslocale ProcScript function to specify a an NLS locale. You can override the behavior specified by NLS locale by setting $NLS_FORMAT or $nlsformat. For more information, see Parsing and Displaying Date and Time Data.

Note: In Dynamic Server Pages, display formats for date and time may not be applied as expected, depending on the data type of the field, the HTML control to which the field's widget resolves, and the browser used. For more information, see Display Formats for Date and Time in Dynamic Server Pages.

Date

Date Display Formats

Display format

Explanation

d

Day number in one or two digits.

dd

Day number in two digits.

zd

Day number in two digits or one space and one digit.

aa

Two-letter abbreviation for day name; lowercase.

AA

Two-letter abbreviation for day name; uppercase.

Aa

Two-letter abbreviation for day name; initial letter is capitalized.

aa*

Full day name; lowercase.

AA*

Full day name; uppercase.

Aa*

Full day name; initial letter is capitalized.

aaa

Three-letter abbreviation for day name; lowercase.

AAA

Three-letter abbreviation for day name; uppercase.

Aaa

Three-letter abbreviation for day name; initial letter is capitalized.

m

Month number in one or two digits.

mm

Month number in two digits.

zm

Month number in two digits or one space and one digit.

mmm

Three-letter abbreviation for month; lowercase.

MMM

Three-letter abbreviation for month; uppercase.

Mmm

Three-letter abbreviation for month; initial letter is capitalized.

mmm*

Full month name; lowercase.

MMM*

Full month name; uppercase.

Mmm*

Full month name; initial letter is capitalized.

w

Week number in one or two digits.

ww

Week number in two digits.

zw

Week number in two digits or one space and one digit.

yy

Calendar year in two digits.

yy+nnn

yy-nnn

Calendar year in two digits, plus or minus number for automatic era correction.

yyyy

Calendar year in four digits.

yyyy+nnn

yyyy-nnn

Calendar year, plus or minus number for automatic era correction.

xx

Fiscal year in two digits. Not supported in DSPs.

xx+nnn

xx-nnn

Fiscal year in two digits, plus or minus number for automatic era correction. Not supported in DSPs.

xxxx

Fiscal year in four digits. Not supported in DSPs.

xxxx+nnn

xxxx-nnn

Fiscal year in four digits, plus or minus number for automatic era correction. Not supported in DSPs.

L code

Number of days, months or years as a linear value, using one of the above codes. Not supported in DSPs.

Date Display Format Examples

Date and Linear Date Fields

Display Format

Displayed (1)

Displayed (2)

Mmm* d, yyyy

March 16, 1995

June 2, 2010

AA, MMM d

WED, MAR 16

THU, JUN 2

dd/mm/yy

16/03/95

02/06/10

mm/dd/yy

03/16/95

06/02/10

d/m/yy

16/3/95

2/6/10

zd/zm/yy

16/ 3/95

2/ 6/10

dd-mm-yyyy+543 (for Thai era) 1

16-03-2538

02-06-2662

Lzd.yyyy 1

25 December, 1990

359.1990

Ldd.mm.yyyy 1

25 December, 1990

25.12.1990

Ldd.mm.yyyy 1

25 days and 11 months

25.11.0

1Not supported in DSPs.

Time

Time Display Formats

Display format

Explanation

h

Hours in one or two digits.

hh

Hours in two digits.

zh

Hours in two digits or one space and one digit.

n

Minutes in one or two digits.

nn

Minutes in two digits.

zn

Minutes in two digits or one space and one digit.

s

Seconds in one or two digits.

ss

Seconds in two digits.

zs

Seconds in two digits or one space and one digit.

lh

Number of hours as linear value. Not supported in DSPs.

ln

Number of minutes as linear value. Not supported in DSPs.

ls

Number of seconds as linear value. Not supported in DSPs.

t

‘Ticks’ (1/100 seconds).

Time Display Format Examples

Time and Linear Fields

Display format

Displayed

 

hh:nn

16:15 or 09:05

 

h:nn

16:15 or 9:05

 

hh:nn.ss

16:15.2 or 09:05.0

 

h:nn.s

16:15.2 or 9:05.3

 

zh:zm.zs

16:15.2 or 9: 5. 3

 

Lzzd.zh.zn.zs 1

27 days, 3 hours, 31 minutes

27.3.31.0

Lzzd.zh.zn.zs 1

71 minutes, 29 seconds

0.1.11.29
1Not supported in DSPs.
Combined Date and Time Fields

Display format

Displayed

dd MMM yyyy hh:nn:ss

2 APR 1991 14:15:39

$NLS Display Formats for Date and Time

You can apply a locale-based display format to a date or time field using the $NLS format.

On Windows , if $nlsLocale is set to system:

  • For the date, MEDIUM is mapped to SHORT, and FULL is mapped to LONG
  • For the time, all are mapped to SHORT

In dynamic server pages, $NLS formats can be applied, but text will be in English.

$NLS Display Formats for Date and Time

Display Format

Shorthand Syntax

Locale

Result

$NLS(SHORT)

DIS($NLS(SHORT))

 

SHORT format for the data type and locale

$NLS(SHORT, DATE)

DIS($NLS(SHORT, DATE))

en_US

2/23/10

en_GB1

23/02/2010

fr_CA1

10-02-23

$NLS(SHORT, TIME)

DIS($NLS(SHORT, TIME))

en_US

9:13 AM

en_GB1

09:13

fr_CA1

09:13

$NLS(SHORT, DATIM)

DIS($NLS(SHORT, DATIM))

en_US

2/23/10 09:13

en_GB1

23/02/2010 09:13

fr_CA1

10-02-23 09:13

$NLS(MEDIUM)

DIS($NLS(MEDIUM))

 

MEDIUM format for the data type and locale

$NLS(MEDIUM, DATE)

DIS($NLS(MEDIUM, DATE))

en_US

Feb 23, 2010

en_GB1

23 Feb 2010

fr_CA1

2010-02-23

$NLS(MEDIUM, TIME)

DIS($NLS(MEDIUM, TIME))

en_US

9:13:33 AM

en_GB1

09:13:33

fr_CA1

09:13:33

$NLS(MEDIUM, DATIM)

DIS($NLS(MEDIUM, DATIM))

en_US

en_GB1

fr_CA1

Feb 23, 2010

23 Feb 2010 09:13:33

2010-02-23 09:13:33

$NLS(LONG)

DIS($NLS(LONG))

 

LONG format for the data type and locale

$NLS(LONG, DATE)

DIS($NLS(LONG, DATE))

en_US

February 23, 2010

en_GB1

23 February 2010

fr_CA1

23 février 2010

$NLS(LONG, TIME)

DIS($NLS(LONG, TIME))

en_US

en_UK1

fr_CA1

9:13:33 AM

09:13:33

09:13:33

$NLS(LONG, DATIM)

DIS($NLS(LONG, DATIM))

en_US

February 23, 2010 9:13:33 AM

en_GB1

23 February 2010 09:13:33

fr_CA1

23 février 2010 09:13:33

$NLS(FULL)

DIS($NLS(FULL))

 

FULL format for the data type and locale

$NLS(FULL, DATE)

DIS($NLS(FULL, DATE))

en_US

Tuesday, February 23, 2010

en_GB1

Tuesday, 23 February 2010

fr_CA1

mardi 23 février 2010

$NLS(FULL, TIME)

DIS($NLS(FULL, TIME))

en_US

9:13:33 AM

en_GB1

09:13:33

fr_CA1

09:13:33

$NLS(FULL, DATIM)

DIS($NLS(FULL, DATIM))

en_US

Tuesday, February 23, 2010 9:13:33 AM

en_GB1

Tuesday, 23 February 2010 09:13:33

fr_CA1

mardi 23 février 2010 09:13:33

$NLS(FormatPattern)

DIS($NLS(FormatPattern))

For example:

DIS($NLS("Aa*, dd-Mmm*-yyyy"))

en_US

Tuesday, 23-February-2010

en_GB1

Tuesday, 23-February-2010

fr_CA1

Mardi, 23-Février-2010

1Not supported in DSPs.

Japanese Era Date Formats

The traditional dating system in Japan as based on the reigns of the emperors. Uniface provides language setups for modern Japanese eras in usource.xml.

Modern Japanese Eras

Date

Japanese Era (Kanji)

Japanese Era (Western)

1868-1912

Meiji

Meiji

1912-1926

Taisho

Taishō

1926-1989

Showa

Shōwa

1989 to present

Heisei

Heisei

To display the Japanese era, set the field layout definition to J or JJ. For example: dis(j-mm-dd) displays Graphical content.10-08-11

Note:  You must have the Kanji font available on your machine.

Uniface Logo A

Send feedback about this topic to Uniface.