Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 01 Mar 2008 @ 11:33:43 GMT


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


Subj:   How to display complete month name
 
From:   gagan.bharadia

Hi ALL,

     sel current_date(format 'mmm');

it only gives first three character of month.

Is there any way in teradata to display full name of month like march,april etc.(By using case,I got it)

But is there any other simplified way to do that.


Gagan



     
  <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: 27 Dec 2016