Timestamp edit patterns use all of the specifiers in both the date and time edit patterns. In addition, timestamp edit patterns include a pattern for microseconds. These fractional portions of a second can be specified using from 1 to 6 digits of precision. Also, the MM component is ambiguous between dates (month of the year) and times (minutes after the hour). MM used in a timestamp edit pattern will be assumed to be the month of the year, MI will be the minutes after the hour.
The following table lists the descriptions for all the specifiers:
|
Specifier |
Description |
|---|---|
|
N |
1-digit fractional second (1/10th Second) |
|
NN |
2-digit fractional second (1/100th Second) |
|
NNN |
3-digit fractional second (1/1000th Second) or milliseconds |
|
NNNN |
4-digit fractional second (1/10,000th Second) |
|
NNNNN |
5-digit fractional second (1/100,000th Second) |
|
NNNNNN |
6-digit fractional second (1/1,000,000th Second) or microseconds |
The following table lists all of the timestamp format specifiers.
|
Internal Timestamp (YYYYMMDDHHMISSNNNNNN) |
|
|
|---|---|---|
|
19960528123456123456 |
HH:MI:SS.N |
12:34:56.1 |
|
19960528123456123456 |
12:MI:SS.NN PM |
12:34:56.12 AM |
|
19960528234500123456 |
12:MI:SS.NNN PM |
11:45:00.123 PM |
|
Copyright © 2013 CA.
All rights reserved.
|
|