18. Working with Data Types and Data Display Formats : Date and Time Templates : Absolute Date and Time Templates : Absolute Date and Time Examples
 
Share this page                  
Absolute Date and Time Examples
The following table demonstrates the use of absolute date and time templates:
Format Template
Example Data
Output
d'2/3/1'
25‑oct‑1998
10/25/98
D'2/3/1'
5‑jun‑1909
6/5/9
d' 2/ 3/01'
25‑oct‑1998
10/25/98
d' 2/ 3/01'
5‑jun‑1909
6/ 5/09
d'03‑02‑01'
5‑oct‑1998
07:24:12
05‑10‑98
d'010203'
5‑oct‑1997
971005
d'1\|2\|3'
5‑oct‑1997
97|10|5
d'FEBRUARY, 1901'
1‑sep‑2134 09:13:02
SEPTEMBER 2134
d'FEBRUARY, 1901'
7‑may‑1962 13:08:42
MAY 1962
d'Sunday'
5‑oct‑1998
Wednesday
d'SUN Feb 3 16:05 1901'
13‑oct‑1998 07:24:03
THU Oct 13 07:24 1998
d'FEB 03 4:05:06 p.m.'
12‑dec‑1998 22:13:03
DEC 12 10:13:03 p.m.
d'04:05:06 PM'
5‑oct‑1998
14:08:45
02:08:45 PM
d'04:05:06 PM'
5‑oct‑1998
07:29:12
07:29:12 AM
d 16:05 pst
5‑oct‑1998
14:08:45
14:08 pst
d'3/01'
5‑oct‑1998
278/98
d'February 3rd'
29‑jul‑1954
July 29th
d'3rd day of 1901'
11‑may‑1999
131st day of 1999