Archives of the TeradataForum

Message Posted: Tue, 08 Feb 2011 @ 12:49:45 GMT

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

Check this

     select date;

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

         Date
     --------
     11/02/08

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     sel cast(date as date format 'yyyymmdd');

     sel cast(date as date format 'yyyymmdd');

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

         Date
     --------
     20110208

Thanks

N.Machha

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