Archives of the TeradataForum
Message Posted: Wed, 26 Mar 2003 @ 19:56:11 GMT
If I remember from the old days, minute() is a function supported by the ODBC driver.
In the long-ago-past (first ODBC driver for Teradata), minute(x) just got re-written as (x(INTEGER)/100 MOD 100
This definition worked for the old way of having TIME values as numerics with format '99:99:99.99', but of course would not work for interval datatypes, which didn't yet exist.
I assume somewhere along the way, NCR has updated the way minute() works in ODBC, but perhaps they failed to test all the possible ways it would be used with Intervals. I'd avoid using this function, and stick to what is actually in the SQL language.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|