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 Sagi — — source: Usenet: comp.databases.informix
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
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.