Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 24 Aug 2001 @ 12:12:23 GMT

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

Subj:   Re: Using Time(0)
From:   Cornelius Meade

Because of the way Teradata physically stores DATE and TIME datatypes it should not generally be necessary to reformat them just to select MAX/MIN type values however if you really do need to do this (say to combine separate date and time values into one timestamp value for comparison to another timestamp value, you should be able to accomplish that by using the CAST function to individually format the date and time values prior to concatenating them together. You would then likely need to wrap that clause with other CAST function to format the resulting character string back into a suitable date value for the comparison to your date/time value from elsewhere. In short, I have found there is a lot of flexibility to format the data pretty much any way you would like or need....

  <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