According to the ANSI standard, "The maximum value of
Thanks for the ANSI reference ...but... I interpret that to mean that ANSI required DBs to support TIME(n) where max(n)>=6. Not
that n is always implemented as 6.
i.e. only TIME(6) needs to store the 86,402,000,000 different values. TIME(0) does not.
In fact, if I define a column as TIME(0), I cannot store value (time '19:22:22.2') in it - I get decimal overflow error.
