Archives of the TeradataForum
Message Posted: Thu, 01 Jun 2000 @ 14:48:22 GMT
Hasn't anyone heard of Y2K? Why are dates still being output without the century?
If you want a julian date of format YYDDD loaded correctly you need to 'window' the date.
You have two options;
1) Add an INMOD to the FastLoad to 'window' the date (FastLoad scripts cannot contain the CASE statement)
2) Convert the FastLoad script to MultiLoad and use the CASE statement to 'window' the date.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|