 |
 |
Archives of the TeradataForum
Message Posted: Fri, 24 Aug 2001 @ 12:12:23 GMT
| 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....
| |
