Horton

Thread

  1. day difference

    Jackie Siu <spjackie@polyu.edu.hk> — 2001-06-23T03:31:37Z

    Hi,

Is there exist a function to calculate day difference between two date. For
example: select functionx('1JAN2001','5FEB2001') from abc where .... Then it
returns 36 (days). Thanks for your help.

Jackie

  2. Re: day difference

    Josh Berkus <josh@agliodbs.com> — 2001-06-29T14:43:00Z

    Jackie,
 
> Is there exist a function to calculate day difference between two
> date. For
> example: select functionx('1JAN2001','5FEB2001') from abc where ....
> Then it
> returns 36 (days). Thanks for your help.
>

See the thread entitled "DateDiff" earlier this week, or search the
archives.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

  3. Re: day difference

    Christopher Sawtell <csawtell@xtra.co.nz> — 2001-06-30T04:14:49Z

    Jackie Siu wrote:
> 
> Hi,
> 
> Is there exist a function to calculate day difference between two date. For
> example: select functionx('1JAN2001','5FEB2001') from abc where .... Then it
> returns 36 (days). Thanks for your help.

chris=# select ('5feb2001'::date - '1jan2001'::date) as "Days
Difference";
 Days Difference 
-----------------
              35
(1 row)

chris=# select version();
                            version                            
---------------------------------------------------------------
 PostgreSQL 7.1.1 on i586-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)

-- 
Sincerely etc.,

 NAME       Christopher Sawtell
 CELL PHONE 021 257 4451
 ICQ UIN    45863470
 EMAIL      csawtell @ xtra . co . nz
 CNOTES    
ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

 -->> Please refrain from using HTML or WORD attachments in e-mails to
me <<--