Timestamp Format Codes

This appendix lists valid components that may be specified for Coral8
Engine TIMESTAMPs.

• For all valid input columns, one and only one occurrence
  of a code of the same kind (for example a code for the year) is allowed.
  There can be no ambiguity about any component of the timestamp.

• All designations of year, month, day, hour, minute,
  or second, also read a fewer number of digits than is specified by the
  code. For example, DD reads both two-digit and one-digit day entries.

Column Code	Description	Allowed in Input	Allowed in Output
MM	Month (01-12; JAN = 01)	Y	Y
YYYY	4 digit year.	Y	Y
YYY	Last 3 digits of year.	Y	Y
YY	Last 2 digits of year.	Y	Y
Y	Last digit of year.	Y	Y
Q	Quarter of year (1, 2, 3, 4; JAN-MAR = 1).	N	Y
MON	Abbreviated name of month (JAN, FEB, ...)	Y	Y
MONTH	Name of month, padded with blanks to length of 9 characters JANUARY, FEBRUARY, ...)	Y	Y
RM	Roman numeral month (I-XII; JAN = I).	Y	Y
WW	Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.	N	Y
W	Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh.	N	Y
D	Day of week (1-7; SUNDAY=1).	N	Y
DD	Day of month (1-31).	Y	Y
DDD	Day of year (1-366).	N	Y
DAY	Name of day (SUNDAY, MONDAY, ...).	Y	Y
DY	Abbreviated name of day (SUN, MON, ...).	Y	Y
HH	Hour of day (1-12).	Y	Y
HH12	Hour of day (1-12).	Y	Y
HH24	Hour of day (0-23).	Y	Y
AM	Meridian indicator (AM/PM)	Y	Y
PM	Meridian indicator (AM/PM)	Y	Y
MI	Minute (0-59).	Y	Y
SS	Second (0-59).	Y	Y
SSSSS	Seconds past midnight (0-86399).	Y	Y
SE	Seconds since epoch (January 1, 1970 UTC). This format may only be used by itself, with the FF format, and/or with the time zone codes TZD, TZR, TZH and TZM.	Y	Y
MIC	Microseconds past start of epoch, Jan 1, 1970	Y	Y
FF	Fraction seconds (0-999999). When used in output, FF produces six digits for microseconds. FFFF produces twelve digits, repeating the six digits for microseconds twice. When used in input, FF collects all digits until a non-digit is detected in order to take nano-seconds into account, while using only the microseconds.	Y	Y
MS	Milliseconds since January 1, 1970. When used for input, this format code may only be combined with FF (microseconds) and the timezone codes TZD, TZR, TZH, TZM. All other format code combinations generate errors. Furthermore, when MS is used with FF, the MS code must precede the FF code: for example, MS.FF.	Y	Y
FM	Fill mode toggle: suppress zeros and blanks or not (default: not).	Y	Y
FX	Exact mode toggle: match case, punctuations, etc. exactly (default: not).	Y	Y
RR	Lets you store 20th century dates in the 21st century using only two digits	Y	N
RRRR	Round year. Accepts either 4-digit or 2 digit input. If 2-digit, provides the same return as RR.	Y	N
TZD	Abbreviated timezone designator such as PST.	Y	Y
TZH	Timezone hour displacement. For example, -5 indicates a timezone five hours earlier than GMT.	N	Y
TZM	Timezone minute displacement. For example, -5:30 indicates a timezone that is 5 hours and thirty minutes earlier than GMT.	N	Y
TZR	Timezone region name. For example, US/Pacific for PST.	N	Y

本文转自

http://www.coral8.com/system/files/assets/docs/WebHelp/mergedProjects/CCL%2520Reference/c8ref_ap_timestamp_formats.html