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.

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 (1KB).

Qualifier Definitions
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.