Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1CEuDx07500
	for <pgsql-sql@postgresql.org>; Mon, 12 Feb 2001 09:56:13 -0500 (EST)
	(envelope-from pgsql-sql-owner@postgresql.org)
Received: from hotmail.com (f125.law7.hotmail.com [216.33.237.125])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f184vWx40465
	for <pgsql-sql@postgresql.org>; Wed, 7 Feb 2001 23:57:32 -0500 (EST)
	(envelope-from manjulkatare@hotmail.com)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Wed, 7 Feb 2001 20:57:27 -0800
Received: from 203.145.132.11 by lw7fd.law7.hotmail.msn.com with HTTP;
	Thu, 08 Feb 2001 04:57:26 GMT
X-Originating-IP: [203.145.132.11]
From: "manjul katare" <manjulkatare@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: sql query
Date: Thu, 08 Feb 2001 10:27:26 +0530
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F125S8cdVhairA9JK3r0000c090@hotmail.com>
X-OriginalArrivalTime: 08 Feb 2001 04:57:27.0110 (UTC)
	FILETIME=[A2051E60:01C0918B]
X-Archive-Number: 200102/201
X-Sequence-Number: 1388

sir ,
kindly send me the solution of the above query.

1.
To calculate th no. of days between 01/01/2000 to 03/02/2001.
2.
TO calculate th time in newfoundland from centra standard time from
02-22-97 ,05.00 am.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.