Querying date_time for date only ? - Mailing list pgsql-sql

From Aarni Ruuhimäki
Subject Querying date_time for date only ?
Date
Msg-id 200512201459.07358.aarni@kymi.com
Whole thread Raw
Responses Re: Querying date_time for date only ?  (Michael Burke <michael@engtech.ca>)
Re: Querying date_time for date only ?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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
--------------


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Rule causes baffling error
Next
From: Michael Burke
Date:
Subject: Re: Querying date_time for date only ?