Michael Burke <[EMAIL PROTECTED]> writes: > On December 20, 2005 08:59 am, Aarni Ruuhimäki wrote: >> 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.
> You can try, > SELECT field::date FROM mytable; The date_trunc() function can also be useful for this sort of thing, particularly if you need to round off to something finer or coarser than days. http://www.postgresql.org/docs/8.1/static/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
