Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 27 Aug 2010 @ 15:03:25 GMT


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


Subj:   Strange results - Date Formatting
 
From:   JAMES PARK

TD 13.0 on Windows Server.

1) When I execute these two queries,

     SELECT CURRENT_DATE (FORMAT 'Y4:M4:D3'); SELECT CURRENT_DATE (FORMAT 'Y4-M3-DD');

I get one result,

     Current Date
     8/27/2010

This is not what I expect to see. The format doesn't work. Why does this happen?


2) This query, SEL CURRENT_DATE (FORMAT 'YYYY/MM/DD); doesn't run while below three run and produce results. Why is it so?

     SEL CURRENT_DATE (FORMAT 'DDbMMMbYYYY'); SEL CURRENT_DATE (FORMAT 'mmmBdd,Byyyy'); SEL
     CURRENT_DATE (FORMAT 'DD.MM.YYYY');


     
  <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