From: "Joel Fradkin" <jfradkin@wazagua.com>
To: "'Achilleus Mantzios'" <achill@matrix.gatewaynet.com>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: datediff is there something like it?
Date: Tue, 25 Jan 2005 12:54:25 -0500
Message-ID: <000201c50306$e9c1b380$797ba8c0@jfradkin>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="ISO-8859-7"
Content-Transfer-Encoding: quoted-printable
In-Reply-To: <Pine.LNX.4.44.0501251832000.32584-100000@matrix.gatewaynet.com>

Yes I am using datepart, but not seeing how with a datediff.
Maybe I just need to do the date math and put a date part on the result.
I will play around a bit when I hit one not looking for days.

Joel Fradkin
=20
Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.  941-753-7111 ext 305
=20
jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced tools.
=A9 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.
=20

=20

-----Original Message-----
From: Achilleus Mantzios [mailto:achill@matrix.gatewaynet.com]=20
Sent: Tuesday, January 25, 2005 11:34 AM
To: Joel Fradkin
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] datediff is there something like it?

O Joel Fradkin =DD=E3=F1=E1=F8=E5 =F3=F4=E9=F2 Jan 25, 2005 :

> Hi all working my way through our views and all is going very well.
>=20
> We use datediff in MSSQL a bit and I read about the field1::date -
> field2::date to return the days numerically.
>=20
> Is there any way to get months and years besides guessing days / 30 =
for
> months etc?

Go to=20
http://www.postgresql.org/docs/7.4/interactive/functions-datetime.html
Check out smth like...

SELECT 'Achilleus is ' || date_part('years',age(timestamp '1969-01-31')) =

|| ' years and ' || date_part('months',age(timestamp '1969-01-31')) || ' =

months old';
                ?column?
-----------------------------------------
 Achilleus is 35 years and 11 months old
(1 row)


>=20
> =20
>=20
> Joel Fradkin
>=20
> =20
>=20
> Wazagua, Inc.
> 2520 Trailmate Dr
> Sarasota, Florida 34243
> Tel.  941-753-7111 ext 305
>=20
> =20
>=20
> 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.
>=20
> =20
>=20
>=20
> =20
>=20
> =20
>=20
>=20

--=20
-Achilleus