Re: comparing dates with timestamps ?

From: Mike Rylander <mrylander(at)gmail(dot)com>
To: raptor <raptor(at)tvskat(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: comparing dates with timestamps ?
Date: 2005-02-13 17:04:58
Message-ID: b918cf3d0502130904499c602e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 13 Feb 2005 18:57:30 +0200, raptor <raptor(at)tvskat(dot)net> wrote:
> how to compare dates with timestamp..if i dont care about
> the hour:minute part of the timestamp... i.e. i want
> to be able to do exact match :
>
> timestamp in (select date from table where .....)

timestamp::DATE in ((select date from table where...))

--
Mike Rylander
mrylander(at)gmail(dot)com
GPLS -- PINES Development
Database Developer
http://open-ils.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2005-02-13 18:01:41 Re: [GENERAL] Website Documentation
Previous Message raptor 2005-02-13 16:57:30 comparing dates with timestamps ?