Formatting timestamps in fastload job script 2

[nandn]

Hello,

I am new to Teradata and I am looking to figure out how to load datetime info using a fastload job script. Here is the format I have: 'MM/DD/YYYY HH:MI'. I know how to convert this in multiload using the substr commands, but I need to use fastload and there does not appear to be an equivalent. I have heard you can use format string with V2R5, but I can't seem to find documentation on how to use the format string commands in the fastload job scripts.

Any help would be greatly appreciated.

 

[dnoeth]

Untested:

DEFINE
...
mycol (char(8))
...

INSERT INTO mytab
VALUES (
...
:mycol (timestamp, format 'MM/DD/YYYY HH:MI')
...


Dieter

 

[dnoeth]

Untested:

DEFINE
...
mycol (char(16))
...

INSERT INTO mytab
VALUES (
...
:mycol (timestamp, format 'MM/DD/YYYY HH:MI')
...


Dieter