Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Mar 2003 @ 11:45:00 GMT


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


Subj:   Simple query - what should be the o/p?
 
From:   Narayan Murthy K S

All,

What should be the output of the following :

Select 1 where time(date) = time(date);

"time(date)" is a cast of "time to date" !!!

What would be the use of such a cast, if it were to be valid?


Thanks,

Narayan Murthy K S



     
  <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