Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 08 Feb 2011 @ 12:25:38 GMT


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


Subj:   Converting TIMESTAMP to DATE
 
From:   Jepamony, Johnpaul

Hi Experts,

I have a requirement to convert TIMESTAMP(2010-08-13 11:56:31) to DATE(20100813).

Below query I used to extract the date..

     Sel cast(Crdtd_Dt as date)..

This resulted 2010-08-13

Again I reframed it to

     sel cast(cast(Crdtd_Dt as date) AS date format 'yyyymmdd')..

Which resulted same as above 2010-08-13

Could any oney help me in fixing this..


Thanks in Advance

John



     
  <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