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.
Qualifier |
Definition |
|---|---|
yy |
Last 2 digits of year. |
yyyy |
All 4 digits of year. |
mm |
Month or minute (recognized by context). |
mon |
Month abbreviation in 3 characters: 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. |
|
|
