Archives of the TeradataForum
Message Posted: Tue, 23 Nov 2004 @ 17:28:38 GMT
<-- Anonymously Posted: Tuesday, November 23, 2004 11:42 -->
I am trying to Multiload a file, but cannot get a 'Time' value to load. I have tried several different options, but keep getting varying errors for Datetime value.
The time values I want to load are Char(6) on the input file. E.g. '034558' for 03:45:58 a.m.
Please can someone tell me how to specify this in the multiload script so I can get the data to load into a column on Teradata which is defined as Time(0)?
I have searched several manuals and cannot find this topic.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|