Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!olivea!oliveb!pyramid!infmx!markj
From: markj@informix.com (Mark Jeske(Chicago Consultan)t)
Newsgroups: comp.databases
Subject: Re: Dates and INFORMIX
Message-ID: <1990Oct13.014427.26282@informix.com>
Date: 13 Oct 90 01:44:27 GMT
References: <1990Oct11.060258.280@monu6.cc.monash.edu.au>
Sender: news@informix.com (Usenet News)
Organization: Informix Software, Inc.
Lines: 30

In article <1990Oct11.060258.280@monu6.cc.monash.edu.au> edd842c@monu6.cc.monash.edu.au (j.e. 8842141 osborn) writes:
>I have a question regarding the computation of the number of
>days between dates in Informix.
>
>eg. The number of days between 10-10-90 and 12-11-90
>
>I have searched through the manuals and can't find any Jullian
>Date functions etc. 

Date types can simply be subtracted to get the number of days between
them.  They are simply stored as integers.  for example:


  main
    define
      d1,d2   date,
      dif     integer

    let d1 = "10-10-90"
    let d2 = "12-11-90"
  
    let diff = d2 - d1
    display diff
  end main

gives  61


Mark Jeske (Chicago consulting)
markj@infmx.com