Re: date - time calculation

> >> I am searching for some tools, which are able to handle date and time > >> (add, subtract, period at least between 1900 and 2020 ). > >> > >> Please can you help me? > >> ... text removed... > I only know those informix functions, which are described in the informix > manual version 5.0. Especially the arithmetic functions are completely > missing there. If you've got 5.0, you should have the "Guide to SQL" manuals. Look up everything about DATETIME in there. By using the DATETIME and INTERVAL datatypes, in conjunction with such functions as EXTEND(), you should be able to do everything you need; though the usage can be a little cryptic at times. The only thing you may find missing is handling of dates after 31/12/1999. Perhaps that's in 6.00, I'm not sure. > The format routines for a datetime dump core very often. As far as I know there is little / nothing you can do to influence the input / display formatting of datetimes. In other words, its not surprising you get problem because you're not supposed to do it. You have to stick with the pre-defined formats. Otherwise you'd have to use EXTEND() to put the different components into DATE and CHAR datatypes, and format those. akent@cix.compulink.co.uk (Andy Kent) -------------------------------------