Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: How to change date formats in views?
From:   Joseph V D silva

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020