Postgres Pro
Downloads
Home   >   mailing lists

DateDiff in PostgreSQL - Mailing list pgsql-sql

From George A.J
Subject DateDiff in PostgreSQL
Date
Msg-id 20031107133409.25844.qmail@web14909.mail.yahoo.com
Whole thread Raw
In response to search facilities  ("Martin Kuria" <martinkuria@hotmail.com>)
Responses Re: DateDiff in PostgreSQL  (Tomasz Myrta <jasiek@klaster.net>)
Re: DateDiff in PostgreSQL  (Rod Taylor <pg@rbt.ca>)
Re: DateDiff in PostgreSQL  (Yasir Malik <ymalik@heineken.cs.stevens-tech.edu>)
List pgsql-sql
Tree view 
<p>Hi,<p>i am converting a MSSQL Server database to PostgreSQL.<p>Using PostgreSQL version 7.3.2.<p>Is there any
functionlike the DateDiff() in MSSQL Server. <p>ie, a function that returns difference of two dates(timestamp) in days
ormonths or year..<p>The - operator for timestamp retuns the intervel in days only.<p>Please help<p>jinujose<p><hr
size="1"/> Do you Yahoo!?<br /><a href="http://antispam.yahoo.com/whatsnewfree">Protect your identity with Yahoo! Mail
AddressGuard</a>

pgsql-sql by date:

Previous
From: "Martin Kuria"
Date:
Subject: search facilities
Next
From: Yasir Malik
Date:
Subject: Re: DateDiff in PostgreSQL