X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id B42C4D1B4E5
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  7 Nov 2003 13:34:38 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 13626-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  7 Nov 2003 09:34:10 -0400 (AST)
Received: from web14909.mail.yahoo.com (web14909.mail.yahoo.com
	[216.136.225.61])
	by svr1.postgresql.org (Postfix) with SMTP id 644FED1B507
	for <pgsql-sql@postgresql.org>; Fri,  7 Nov 2003 09:34:06 -0400 (AST)
Message-ID: <20031107133409.25844.qmail@web14909.mail.yahoo.com>
Received: from [202.9.168.133] by web14909.mail.yahoo.com via HTTP;
	Fri, 07 Nov 2003 05:34:09 PST
Date: Fri, 7 Nov 2003 05:34:09 -0800 (PST)
From: "George A.J" <jinujosein@yahoo.com>
Subject: DateDiff in PostgreSQL
To: pgsql-sql@postgresql.org
In-Reply-To: <Sea2-F69mvu0wXqkv4e00044063@hotmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1357030754-1068212049=:25074"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_10_20,
	IN_REP_TO
X-Spam-Level: 
X-Archive-Number: 200311/38
X-Sequence-Number: 15853

--0-1357030754-1068212049=:25074
Content-Type: text/plain; charset=us-ascii


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
--0-1357030754-1068212049=:25074
Content-Type: text/html; charset=us-ascii

<P>Hi,</P>
<P>i am converting a MSSQL Server database to PostgreSQL.</P>
<P>Using PostgreSQL version 7.3.2.</P>
<P>Is there any function like the DateDiff() in MSSQL Server. </P>
<P>ie, a function that returns difference of two dates(timestamp) in days or months or year..</P>
<P>The - operator for timestamp retuns the intervel in days only.</P>
<P>Please help</P>
<P>jinujose</P><p><hr SIZE=1>
Do you Yahoo!?<br>
<a href="http://antispam.yahoo.com/whatsnewfree">Protect your identity with Yahoo! Mail AddressGuard</a>
--0-1357030754-1068212049=:25074--