DateDiff in PostgreSQL

From: "George A(dot)J" <jinujosein(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: DateDiff in PostgreSQL
Date: 2003-11-07 13:34:09
Message-ID: 20031107133409.25844.qmail@web14909.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi,

i am converting a MSSQL Server database to PostgreSQL.

Using PostgreSQL version 7.3.2.

Is there any function like the DateDiff() in MSSQL Server.

ie, a function that returns difference of two dates(timestamp) in days or months or year..

The - operator for timestamp retuns the intervel in days only.

Please help

jinujose

---------------------------------
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Yasir Malik 2003-11-07 13:40:52 Re: DateDiff in PostgreSQL
Previous Message enio 2003-11-07 12:53:08 Getting the row_count value outside of a function