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 .....) tia ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq