Archives of the TeradataForum
Message Posted: Fri, 13 Jul 2001 @ 14:22:32 GMT
The short answer to your question is no. Or yes, it is using all 6 positions, but the last 4 are always 0.
There are a couple of things to note here.
- TIME and TIMESTAMP are ANSI constructs. They have been defined as having a maximum of 6 decimal places because many DBMSes, including DB2 on OS/390, can indeed capture time down to the microsecond. However, not every DBMS is required to meet this standard.
- The resolution you can actually get depends on the hardware and the operating system support. Our system is running on NCR WorldMark with MP-RAS; on this system, there is no way to get anything below centiseconds. Under NT or Solaris, there may be.
The following C program, run on an application node, will show you exactly what the OS provides.
=== gtod.c === #include
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|