Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016