Re: Manipulating datetime

Mark Secrist writes: |> I am trying to do some realatively simple math with datetime variables. |> At least it is realatively simple from 4gl. I have datetime t1 (Year to Minute) |> and t2 of the same range. I have an interfal of d1 (Day to Minute) and I |> want to have d1 = t2 - t1. |> I have a document written by Dave Kosenko which refers to some undocumented |> functions available in 4.0 ESQL/C. I now have 5.0 ESQL/C and they STILL are |> undocumented. In my opinion this is a serious oversight. Does anyone know |> anything more? New functions are provided with 6.0 ESQL/C to do datetime and interval arithmetic. These are different functions than those in the document you mention (which are pretty messy to use). Essentially, they wrote a set of easier-to-use functions to do the job. Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney