Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 27 Aug 2010 @ 15:46:07 GMT


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


Subj:   Re: Strange results - Date Formatting
 
From:   Alves, Patrick

if you request DB thru ODBC, format phrase will not apply. ODBC will force the format with local regional setting.

If you want the format that you specified you need to cast your data into varchar

     SELECT CURRENT_DATE (FORMAT 'Y4:M4:D3') (varchar(50))

Regards.

PAtrick



     
  <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: 15 Jun 2023