Archives of the TeradataForum

Message Posted: Wed, 19 Jul 2006 @ 10:06:54 GMT

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

Ah that's probably the winddi/queryman teasing you .......

you should get it right if you query from the bteq .....

alternatively you can try this.

     select (calendar_date (format 'mmmyy' )) (char (5))
     from sys_calendar.calendar
     sample 10
     ;

Joseph Vinish D'silva

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