Chapter 10: Using Destination-Template Transfer

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, using the following 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).

The following table 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.

Copyright © 2005. Sybase Inc. All rights reserved.

Destination-template processing

View this book as PDF