Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 08 Feb 2011 @ 13:19:36 GMT

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

Subj:   Re: Converting TIMESTAMP to DATE
From:   Tewksbury, Kevin

If you are doing this in SQLA, you always get system default format for date. SQLA does not handle format very well. Try running in bteq mode.

     select cast(current_timestamp as date FORMAT 'YYYYMMDD');


  <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