Archives of the TeradataForum

Message Posted: Wed, 27 Oct 2004 @ 13:09:07 GMT

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

2) Is there any (alternative) way to CAST a date field to 'yyyy/mm/dd' format?? as we cannot use it in Fastload script.

     DEFINE ...
          ,in_sls_dt             (varchar(10))  /* or char(10) */
     ...;

     insert ...
        ,:in_sls_dt       (date, format 'mm/dd/yyyy')
     ...;

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