Use the DATETIME conversion option to insert ASCII data that is stored in a fixed format into a TIME, TIMESTAMP, or DATETIME column.
This option converts the ASCII data input to binary and specifies the format of the input data. (The DATETIME format is used internally to interpret the input; it does not affect the storage or output format of the data.)
DATETIME ('input-datetime-format')
LOAD TABLE lineitem( l_quantity ASCII(4), l_shipdate DATETIME('MM/DD/YY hh:mm:ss'), FILLER(1)) FROM '/d1/MILL1/tt.t' PREVIEW ON
LOAD TABLE snapquote_stats_base SYMBOL ‘\x09’, snaptime DATETIME('MM/DD/YY hh:mm:ss'), FILLER(1)) VWAP ‘\x09’, RS_DAY ‘\x09’, FROM '/d1/MILL1/tt.t' PREVIEW ON
LOAD TABLE Customers( open_time DATETIME('hh:mmaa'), close_time DATETIME('hh:mmaa'), FILLER(9)) FROM '/d1/MILL1/tt.t' PREVIEW ON