Re: Datetime and Interval

You can convert from, say, interval minute(9) to minute to char variable and then from this char to an int variable to get an integer value for minutes. ..mk TOMMY wrote: > Jonathan Leffler wrote: > > > Peter Howe wrote: > > > Just as an aside... > > > > > > Why does Informix use a DATETIME type instead of the the > > > SQL TIMESTAMP type? > > > > AFAIK, Informix implemented a draft version of the SQL-92 standard > > DATETIME handling, and the draft changed before the standard was > > finalized, but Informix had released the product. > > > > TIMESTAMP corresponds to DATETIME YEAR TO SECOND. > > Tanks Jonathan,Peter but I've the problem with a DB that now running for an > application and my application (taking information from the DB) need know > the number of minutes > that was spent from DATA1 to DATA2 two DATETIME YEAR TO FRACTION > My problem is it's possible that the difference from two DATE MUST BE AN > INTERVALL > and not an integer ???? > Can I resolve this problem with SPL ?? > > Massimiliano Panella > Tank You