Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 23 Feb 2006 @ 22:54:22 GMT


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


Subj:   Re: Odd error - Invalid operation on an ANSI Date/Time
 
From:   Joe Celko

  This seems a bit odd tough to have to cast to character, substring, and then cast back to time(0). Is there another way?  


You are mopping the floor, instead of fixing the leak. Add a constrant that keeps your temporal data in a format that works for you instead of letting it vary. Think DDL and DML. I would also use a BETWEEN predicate to make the code easier to maintain and read.



     
  <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