Date: Mon, 28 Feb 2005 14:37:05 -0500
From: "Joel Fradkin" <jfradkin@wazagua.com>
Subject: Re: diference in dates in minutes
In-reply-to: <20050228152441.GA16739@wolff.to>
To: "'Bruno Wolff III'" <bruno@wolff.to>
Cc: <pgsql-sql@postgresql.org>
Message-id: <001301c51dcc$e38f4b40$797ba8c0@jfradkin>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: quoted-printable

Sorry you are correct again it is TimeStamp not date.
So maybe that is why it appeared to work ok.
I will do as you suggest and play around with it before I accept it is a
perfect solution, but it appeared to do what I was looking for (figure =
the
difference in minutes).


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.
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

-----Original Message-----
From: pgsql-sql-owner@postgresql.org =
[mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Bruno Wolff III
Sent: Monday, February 28, 2005 10:25 AM
To: Joel Fradkin
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] diference in dates in minutes

On Mon, Feb 28, 2005 at 09:09:09 -0500,
  Joel Fradkin <jfradkin@wazagua.com> wrote:
> Yea I probably forgot respond to all. I agree (specialy for this =
topic).
>=20
> In any case, I have dates not time (dates with times).

It really helps if you use precise language when discussing problems.
date, time with time zone, time without time zone, timestamp with time =
zone,
and timestamp without time zone are all different types.

> I did not use datevar::date - date2::date, I did datevar - datevar2 =
and it
> appeared to work.

That can not give you a result that is an interval if datevar and =
datevar2
are actually dates. They must be some other type, probably a timestamp
of some sort.

> Since the dates I was comparing were over a year apart the number in =
secs
> was hard to verify. Soon as I get to debuggin the actual app where the
time
> dif will be a few minutes I will let you know if it worked to do the=20
> date_part('epoch',date-date) returns in secs so /60.

If the date variables are of type timestamp with time zone you should
be OK. You probably want to test comparing dates in different time zones
(if you have different time offsets from GMT at different times of the =
year
at your locale, e.g. daylight savings vs standard time) to make sure you =
get
the expected result.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings