X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E45393A568A for ; Tue, 25 Jan 2005 15:08:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71371-08 for ; Tue, 25 Jan 2005 15:08:38 +0000 (GMT) Received: from out008.verizon.net (out008pub.verizon.net [206.46.170.108]) by svr1.postgresql.org (Postfix) with ESMTP id 237C33A5757 for ; Tue, 25 Jan 2005 15:08:33 +0000 (GMT) Received: from jfradkin ([66.15.127.235]) by out008.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050125150833.TRDZ17379.out008.verizon.net@jfradkin> for ; Tue, 25 Jan 2005 09:08:33 -0600 From: "Joel Fradkin" To: Subject: datediff is there something like it? Date: Tue, 25 Jan 2005 10:11:40 -0500 Message-ID: <000001c502f0$2d10a7c0$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C502C6.443A9FC0" X-Authentication-Info: Submitted using SMTP AUTH at out008.verizon.net from [66.15.127.235] at Tue, 25 Jan 2005 09:08:33 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.079 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: *** X-Archive-Number: 200501/214 X-Sequence-Number: 20002 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C502C6.443A9FC0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi all working my way through our views and all is going very well. We use datediff in MSSQL a bit and I read about the field1::date - field2::date to return the days numerically. Is there any way to get months and years besides guessing days / 30 for months etc? Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments. ------=_NextPart_000_0001_01C502C6.443A9FC0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi all working my way through our views and all is = going very well.

We use datediff in MSSQL a bit and I read about the field1::date – field2::date to return the days = numerically.

Is there any way to get months and years besides = guessing days / 30 for months etc?

Joel Fradkin

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida = 34243
Tel. 941-753-7111 ext 305

jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced = tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
This email message is for the use of the intended recipient(s) and = may contain confidential and privileged information. Any unauthorized = review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete = and destroy all copies of the original message, including = attachments.

------=_NextPart_000_0001_01C502C6.443A9FC0--