Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Apr 2012 @ 10:10:23 GMT


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


Subj:   Re: Joining TIMESTAMP vs DATE
 
From:   Alves, Patrick

Hi,

As i said to customer,SQL is a declarative language, so you have to cast the column to the datatype that you want to convert to.

Teradata permits implicit conversions, and depending on request, execution plan, the column that is converted could be different.

You must cast the column into the rigth datatype .

As i'm writting pros on SQL Teradata, joining columns that have not the same datatype show me that physical model seems not to be built in the state of art.


Regards.

Patrick.
Sr TD Consultant.



     
  <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