Querying date_time for date only ?

From: Aarni Ruuhimäki <aarni(at)kymi(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Querying date_time for date only ?
Date: 2005-12-20 12:59:07
Message-ID: 200512201459.07358.aarni@kymi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello List,

I have a time stamp without time zone field, YYYY-MM-DD hh:mm:ss, in my table.
I want to also find something just for a particular day regardless of the
time.

(Pg)SQL way to do this ?

TIA,

Aarni
--
--------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core** linux system
--------------

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Burke 2005-12-20 13:19:49 Re: Querying date_time for date only ?
Previous Message Richard Huxton 2005-12-20 09:15:39 Re: Rule causes baffling error