Archives of the TeradataForum
Message Posted: Wed, 26 Mar 2003 @ 19:56:11 GMT
Subj: | | Re: Timestamp difference |
|
From: | | Chuck McDevitt |
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.
|