 |
 |
Archives of the TeradataForum
Message Posted: Thu, 26 Aug 2004 @ 17:14:05 GMT
| Subj: | | Re: Overflow error and time(0) |
| |
| From: | | Victor Sokovin |
| | I tried to cast it to 19, but it didn't work in queryman 5.2. | |
ODBC driver sometimes treats timestamps differently than BTEQ. For example, TIME(0) in your query would have the data type of INTEGER when
returned the ODBC driver. You might try switching off the ODBC extensions in the Queryman options. There might be more details on this in the
archives.
| | One more question related to this is: How do we extract seconds(0) from timestamp(6). because extract(seconds from time) always
gives seconds(6). | |
I think you are right about this. Hence the workaround via substrings. BTW, when you mentioned performance difference which queries did you
mean exactly?
Regards,
Victor
| |
