Actian X 11.2 | vwload Date Format Settings

Command Reference Guide > Command Reference Guide > Using Actian X Commands > vwload Command--Load Data into a Table > vwload Date Format Settings

Was this helpful?

vwload Date Format Settings

The ‑‑dateformat format | attr=format option on the vwload command sets the date format for the attribute (column).

Valid settings for format as follows:

Setting	Valid Input Formats	Output Format
US (default)	mm/dd/yy mm-dd-yy mmddyy mm/dd/yyyy mm-dd-yyyy mmddyyyy dd-mmm-yyyy dd mmm yyyy yyyy-mm-dd yyyy.mm.dd yyyy_mm_dd mm-dd mm/dd	dd-mmm-yyyy
MULTINATIONAL	yyyy-mm-dd mm-dd-yy mmddyy mmddyyyy dd/mm/yy dd/mm/yyyy dd mmm yyyy All US formats except mm/dd/yyyy and mm/dd/yy	dd/mm/yy
MULTINATIONAL4	yyyy-mm-dd dd/mm/yy dd/mm/yyyy dd mmm yyyy mm-dd-yy mmddyy mmddyyyy All US formats except mm/dd/yyyy and mm/dd/yy	dd/mm/yyyy
ISO	yyyy-mm-dd yyyymmdd yymmdd ymmdd mmdd mdd dd mmm yyyy All US input formats except mmddyy	yymmdd
ISO4	yyyy-mm-dd yyyymmdd yymmdd ymmdd mmdd mdd dd mmm yyyy All US input formats except mmddyy	yyyymmdd
ISO4T	All ISO4 input formats. If the prefix "T" is used then the absolute time component can use the input format hhmmss as well as the standard hh:mm:ss. For example: Acceptable: yyyymmddThhmmss, yyyymmddThh:mm:ss, and yyyymmdd hh:mm:ss Not acceptable: yyyymmdd hhmmss Acceptable: 'Thhmmss', 'Thh:mm:ss' and 'hh:mm:ss' Not acceptable: 'hhmmss' This is the only case where an absolute time can be entered in format hhmmss instead of hh:mm:ss. To avoid ambiguity, a time field entered in hhmmss format must be 6 characters long.	yyyymmdd ISO4 output format, unless the date includes a time, in which case the format is: yyyymmddThhmmss
ISO4TC	See description under ISO4T.	ISO4 output format, unless the date includes a time, in which case the format is: yyyymmddThh:mm:ss
SWEDEN or FINLAND	yyyy-mm-dd yy-mm-dd mmddyy dd mmm yyyy All US input formats except mm-dd-yyyy	yyyy-mm-dd
GERMAN	yyyy-mm-dd dd.mm.yyyy ddmmyy dmmyy dmmyyyy ddmmyyyy dd mmm yyyy mm-dd-yy All US input formats except yyyy.mm.dd and mmddyy	dd.mm.yyyy
YMD	mm/dd mm-dd mmdd yymdd yymmdd yy-mm-dd yyyymdd yyyy-mmm-dd yyyy/mm/dd yyyy.mm.dd yyyy-mm-dd yyyy_mm_dd yyyymmdd yyyy mmm dd	yyyy-mmm-dd
DMY	yyyy-mm-dd yyyy_mm_dd dd/mm dd-mm ddmm ddmyy dd-mm-yy ddmmyy ddmyyyy ddmmyyyy dd/mm/yyyy dd-mm-yyyy dd.mm.yyyy dd-mmm-yyyy dd mmm yyyy	dd-mmm-yyyy
MDY	yyyy-mm-dd yyyy_mm_dd mm/dd mm-dd mmdd mmddyy mddyy mddyyyy mm-dd-yy mm-dd-yyyy mm/dd/yyyy mm.dd.yyyy mmddyyyy mmm-dd-yyyy	mmm-dd-yyyy

For a date that is missing the century on input, year is determined by the setting on the II_DATE_CENTURY_BOUNDARY environment variable.

In three-character month formats, for example, dd-mmm-yy, specify three-letter abbreviations for the month (for example, mar, apr, may).

To specify the current system date and time, use the constant, NOW.

Last modified date: 04/03/2024