Re: SQL Query over I-STAR
: In "SQL Query over I-STAR" I wrote:
>
> select * from remote_rate
> where
> counter_id = 61 and
> timestamp > (current year to minute - interval(30) minute to minute)
> and I get:
> 1261: Too many digits in the first field of datetime or interval.
If anyone is interested I got this working by changing the query to the
following:
select * from remote_rate
where
counter_id = 61 and
timestamp > (current year to minute - 30 UNITS MINUTE)
Thanks to Graeme Sargent who emailed me the suggestion.
Someone at Informix ought to investigate. I believe the query should
work with either syntax.
Ken Miles
HP Vancouver Division
kenm@vcd.hp.com