 |
 |
Archives of the TeradataForum
Message Posted: Tue, 05 Oct 2004 @ 15:13:00 GMT
| Subj: | | Re: Calculating average age per transaction |
| |
| From: | | Dieter Noeth |
Dennis Calkins wrote:
| | YEAR(4) means a MAXIMUM of 4 DIGITS (9999) in the answer. 4 Digits is the MAXIMUM allowed by ANSI SQL. | |
No, according to ANSI there's no maximum, only a minimum. The number of significant digits is implementation-defined. It would be nice
to have more than 9999 days/hours/minutes/seconds.
Btw, Oracle allows up to 9 digits ;-)
Dieter
| |
