Re: timestamp, microsecs.

[Scott Klement <klemscot@xxxxxxxxxxxx>]

Hi Tim,

>       When I do a timestamp operation I get a field like this...
>       2004-04-23-08.41.56.119000
>
>       Is there ay way to get values in the smallest three places?  I
> remember a C function that Scott posted, but I can't seem to find it in the
> archive...


Two ways that I know of... one is the "gettimeofday" API which retrieves
the time from the software clock (which may matter to you if your software
clock is different from your hardware clock)

The other is embedded SQL, though I have no idea if that comes from the
software or hardware clock?

Here's an SQL sample:

     D wrkTimeStamp    S               Z   Inz( *loval )

     C/exec sql
     C+ set :wrkTimeStamp  = current timestamp
     C/end-exec

     c                   dsply                   wrkTimeStamp
     c                   eval      *inlr =*on

The gettimeofday() method has been posted in these forums (or perhaps it
was MIDRANGE-L?) several times before.  Try searching for "gettimeofday"
either on archive.midrange.com or else in Google...