Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Apr 2012 @ 09:03:30 GMT


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


Subj:   Joining TIMESTAMP vs DATE
 
From:   sathesh.kumar

Hi,

I am joining a timestamp column with a date column in two env.( UAT & PROD) The issue is in UAT env the timestamp column is simplicitly converted to date and in PROD env the reverse is happening ie.. Date is implicitly getting converted to timestamp with 00:00:00 appended.

Because of this I am not getting the data in PROD the same as in UAT.

Kindly help

NOTE : AM using Teradata v13



     
  <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