Archives of the TeradataForum

Message Posted: Thu, 01 Jun 2000 @ 14:48:22 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Simon Norris

	<Prev	Next>		<<First	<Prev	Next>	Last>>