Archives of the TeradataForum
Message Posted: Fri, 24 Aug 2001 @ 10:00:04 GMT
Further to a discussion around May time I have a question upon using the datatype "TIME"
We have some tables that have the time stored in the above datatype that I need to concatenate with a DATE field to make comparisons between records or to select maximum/minimum combinations etc.
However methods that I have tried so far (basic concatenation with/without formatting from manual)have failure written all over them, the message being 'Invalid on an ANSI datetime...'
I have done this before where the time was held in char or integer format and works fine but I cannot even reformat the datatype to either of these datatypes prior to concatenation (as same error message applies).
Does anyone have a solution?
Thanks in advance
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|