 |
 |
Archives of the TeradataForum
Message Posted: Mon, 28 Aug 2000 @ 21:27:03 GMT
| Subj: | | Re: MultiLoad Date Fields |
| |
| From: | | Fred Pluebell |
Glad it's solved.
Mary Lou Arundell" wrote:
| | The (date, Format'YYYYMMDD') did it. | |
| | Fred: In response to your "IF...", "If the input data matches the FORMAT used in CREATE TABLE". I created and recreated the
table with and without a format statement on Junk02. With the format, I tried both "yyyymmdd" and "mmddyyyy", and subsequently
matched the input data to the format specified, as well as the format statement in the MLoad DML. It was never enough. | |
Actually, I think it was "too much". It should work if the .FIELD is CHAR, the table is DATE, the data matches the FORMAT
from the CREATE TABLE, and the MLoad DML has no FORMAT explicitly specified. To supply a character date FORMAT in the DML you must
also request conversion to DATE at the same time.
| |
