Re: IDS 7.3 : Stored procedures tuning
Thanks but I still have some troubles :
> select current from systables where tabid = 1;
> execute procedure fred("right");
> select current from systables where tabid = 1;
The CURRENT function always returns result wich precision is 'truncated' to
second format (fraction part of datetime is always 000) : '2000-04-04
15:21:54 000'. I get this result either in an SQL statement or in a SP. I
read that CURRENT rely on the system date and time API ; I suppose that WinNT
knows millisecond ! So I do not really understand what is the problem !
> Or some variation on that theme.
>
> Or:
>
> SELECT dbinfo('utc_current') in your SP.
Wich format returns this statement (I did not find 'utc_current' in
documentation, what is it ?) because I get an exception of bad conversion
when I set this statement in a DATETIME YEAR TO FRACTION variable ?
Thanks for your help
Arnaud
--
- -------------------------------------------------------------- -
- Arnaud ANDRIEUX arnaud.andrieux@aql.fr -
- Ingenieur en developpement -
- Direction Metier Industrie -
- -------------------------------------------------------------- -
- ALLIANCE QUALITE LOGICIEL http://www.aql.fr -
- Rue de la Chataigneraie -
- B.P. 127 -
- 35513 CESSON SEVIGNE -
- tel : (33) (0)2.99.12.50.00 -
- fax : (33) (0)2.99.63.70.40 -
- -------------------------------------------------------------- -