Archives of the TeradataForum

Message Posted: Wed, 19 Jul 2006 @ 10:02:33 GMT

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

Hi,

I have tried the same and it is working fine.

Example:

a. created the below view:

          CREATE VIEW VISU
          AS
          select CAST(calendar_date AS format 'mmmYY'  ) x
          from sys_calendar.calendar;

b. Output on bteq:

          select * from visu
          sample 2;

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

              x
          -----
          Jun47
          Aug60

NOTE:

On SQL Assitant you won't get the formatted output for date.

Regards,

Vinod Sugur

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