Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jean-
You need to have:
USOSTIME 1
set in your onconfig. Otherwise Informix only updates the time once a second.
--EEM
> -----Original Message-----
> From: Jean Sagi [mailto:jeansagi@myrealbox.com]
> Sent: Friday, September 24, 2004 4:11 PM
> To: informix-list@iiug.org; jeansagi@myrealbox.com
> Subject: Where are the fractions of a second of CURRENT?
>
>
> I haven't seen this before, but when in dbaccess I issue:
>
> select current
> from dual> ;
>
> Informix returns:
>
> ct
> -----------------------
> 2004-09-24 16:06:37.000
>
> 1 row(s) retrieved.
>
> I keep the RUN option (holding R pressed) and I see how the second pass
> but I don't see the fractions of the second...
>
> Why?
>
> If I issue:
>
> select extend(current, year to fraction(5)) ct
> from table( set{1} )
>
> Yet no joy:
>
> ct
> -------------------------
> 2004-09-24 16:09:14.00000
>
> Really interesting?
>
> - Maybe is a disabled option?
> - it's dbaccess? (Although Winsql shows the same behavior).
> - It's the engine
>
>
> Rigth know I'm using
> - IDS 9.30.HC2W8
> - HP-UX ipsilon B.11.00
>
> Any hint would be very appreciated.
>
>
> Chucho!
>
> Jean Sagi
> jeansagi@myrealbox.com
> jeansagi@yahoo.com
>
> sending to informix-list
sending to informix-list
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.