Special date and time qualifiers

You can combine special date and time qualifiers and construct the date or time format that the target database requires, following these rules:

Enter special characters in either uppercase or lowercase.
Separate special characters by any arbitrary character, such as a hyphen, slash, or space. Any unrecognized character is copied to the target as is.
Enclose special characters in single or double quotes, because the resulting value is passed to the target as a character string.
Allow qualifiers to contain a null terminated string. The string is limited only by the buffer size (1k).

Table 10-5 shows qualifier definitions.

**Table 10-5: Special date and time qualifiers**
Qualifier	Definition
yy	Last two digits of year.
yyyy	All four digits of year.
mm	Month or minute (recognized by context).
mon	Three-character month abbreviation: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.
dd	Day.
hh	Hour.
ss	Seconds.
nnn	Milliseconds.
nnnnnn or uuuuuu	Microseconds.
am or pm	Indicates that you want an AM or PM designator included. The actual designator is inserted appropriate to the value.