|
|
Archives of the TeradataForum
Message Posted: Thu, 12 Jun 2008 @ 21:58:46 GMT
Subj: | | Re: Timestamp & six digit second |
|
From: | | Dieter Noeth |
Geoffrey Rommel wrote:
| The precision of current_timestamp(6) depends on the underlying clock and OS. On MP-RAS and the Demo version, it's only two digits. | |
On Linux, too. I think it's based on a C function call, which just returns no greater precision.
| Curiously enough, Microsoft SQL Server returns 3 digits, so the Intel chips must support at least that many. | |
But the last digit is *always* 0, 3 or 7, because the accuracy in SQL Server is only 1/300 of a second, so MS is just fooling the end user
again :-)
Dieter
| |