SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-53
Considerations for import
DateOrder=order
Order of the date fields:
MDY: month/day/year
DYM: day/year/month
YMD: year/month/day
YDM: year/day/month
DMY: day/month/year
MYD: month/year/day
Default is MDY.
DateDelimiter=date_delim
Delimiter for the date. Default is a slash (for
example, mm/dd/yyyy).
TimeDelimiter=time_delim
Delimiter for the time. Default is a colon (for
example, hh:mm:ss).
FourDigitYear=four_year
Y or N. Default is Y; 4 digits (for example,
12/25/1997).
You have the option of specifying a two-digit
year date or timestamp value. If you specify two
digits and the year value is less than 30,
import assumes the first two digits of the year
to be 20. If the year value is greater than or
equal to 30, import assumes the first two digits
of the year to be 19.
DecimalSymbol=decimal
One character. Default is a decimal point (.).
You can specify some character, other than the
default decimal point (.) character, to be used
whenever the input file has a time value that
includes a fractional part of a second. This
DecimalSymbol character is used only with a
fractional second. It is not recognized in general
numeric input, such as 12345.67, or in floating
point numbers. For general numerics and
floating point numbers, you must use the
decimal point.
NormalizeDate=normalize
Y or N. Default is N; no datetime normalization.