Re: informix fraction
tolga@login.com.tr wrote:
>
> Hi everybody,
> Has anybody tried to use datetime fraction in stored procedure or etc?
> I have a problem with this:
> In dbaccess, followin sql statement does not do what i want:
> select current year to fraction(5)
> In result,there is no fraction.
> My customer needs all the fractions of the current time.
> Is there any way to do this?
Check your release notes to see that your platform supports fractions of
a second. Not all do I believe.
If this is IDS or OnLine, check the configuration parameter USEOSTIME is
set to 1. If not the time is set every second, hence no fractions.
Hope that helps,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com http://www.informix.com/idn |///// / //|
|http://www.iiug.org +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+