day difference

From: "Jackie Siu" <spjackie(at)polyu(dot)edu(dot)hk>
To: pgsql-sql(at)postgresql(dot)org
Subject: day difference
Date: 2001-06-23 03:31:37
Message-ID: 9h12ft$1gpg$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2001-06-23 14:02:45 Re: Re: Re: binary data
Previous Message Tom Lane 2001-06-22 21:11:31 Re: View performance question