ZsDuplicateHunter allows you to customize the display of the timestamps displayed within the software by defining the
Timestamp Format
. When you define a format, zsDuplicateHunter will display a
sample format
using the current time so you can ensure that the format is behaving as expected.
You can also control the
Current Time zone
which will help zsDuplicateHunter to properly format dates according to your location.
Timestamp Options Dialog
|
Creating a Timestamp Format
Timestamp formats are specified by date and time pattern strings. Within date and time pattern strings, unquoted letters from 'A' to 'Z' and from 'a' to 'z' are interpreted as pattern letters representing the components of a date or time string. Text can be quoted using single quotes (') to avoid interpretation. "e;''"e; represents a single quote. All other characters are not interpreted; they're simply copied into the output string during formatting or matched against the input string during parsing.
The following pattern letters are defined (all other characters from 'A' to 'Z' and from 'a' to 'z' are reserved):
|
|
|
|
G
|
Era designator
|
Text
|
AD
|
y
|
Year
|
Year
|
1996; 96
|
M
|
Month in year
|
Month
|
July; Jul; 07
|
w
|
Week in year
|
Number
|
27
|
W
|
Week in month
|
Number
|
2
|
D
|
Day in year
|
Number
|
189
|
d
|
Day in month
|
Number
|
10
|
F
|
Day of week in month
|
Number
|
2
|
E
|
Day in week
|
Text
|
Tuesday; Tue
|
a
|
Am/pm marker
|
Text
|
PM
|
H
|
Hour in day (0-23)
|
Number
|
0
|
k
|
Hour in day (1-24)
|
Number
|
24
|
K
|
Hour in am/pm (0-11)
|
Number
|
0
|
h
|
Hour in am/pm (1-12)
|
Number
|
12
|
m
|
Minute in hour
|
Number
|
30
|
s
|
Second in minute
|
Number
|
55
|
S
|
Millisecond
|
Number
|
978
|
z
|
Time zone
|
General time zone
|
Pacific Standard Time; PST; GMT-08:00
|
Z
|
Time zone
|
Relative time zone
|
-0800
|
Pattern letters are usually repeated, as their number determines the exact presentation:
·
|
Text
: If the number of pattern letters is 4 or more, the full form is used; otherwise a short or abbreviated form is used if available.
|
·
|
Number
: If the number of pattern letters is the minimum number of digits, and shorter numbers are zero-padded to this amount.
|
·
|
Year
: If the number of pattern letters is 2, the year is truncated to 2 digits; otherwise it is interpreted as a number.
|
·
|
Month
: If the number of pattern letters is 3 or more, the month is interpreted as text; otherwise, it is interpreted as a number.
|
·
|
General time zone
: Time zones are interpreted as text if they have names. Otherwise, they are interpreted as an offset from Greenwich Mean Time.
|
Examples
The following examples show how date and time patterns are interpreted in the U.S. locale. The given date and time are 2001-07-04 12:08:56 local time in the U.S. Pacific Time time zone.
Date and Time Pattern
|
Result
|
yyyy.MM.dd G 'at' HH:mm:ss z
|
2001.07.04 AD at 12:08:56 PDT
|
EEE, MMM d, ''yy
|
Wed, Jul 4, '01
|
h:mm a
|
12:08 PM
|
hh 'o''clock' a, zzzz
|
12 o'clock PM, Pacific Daylight Time
|
K:mm a, z
|
0:08 PM, PDT
|
yyyyy.MMMMM.dd GGG hh:mm aaa
|
02001.July.04 AD 12:08 PM
|
EEE, d MMM yyyy HH:mm:ss Z
|
Wed, 4 Jul 2001 12:08:56 -0700
|
yyMMddHHmmssZ
|
010704120856-0700
|
|