Bottom quoting makes it difficult to reply properly, so reformated a bit: On Thu, Oct 20, 2016 at 2:02 PM, William Ivanski <william.ivan...@gmail.com> wrote: > Em qui, 20 de out de 2016 às 09:52, Bjørn T Johansen <b...@havleik.no> > escreveu: >> date is of type timestamp. > select * from table where date = '2016/10/20'::date
I think is the other way round ( date::date = '2016/10/20' ). To me it seems yours will do: date = '2016/10/20'::date::timestamp ( = 2016/10/20 00:00:00 ) ( widening conversion ) Francisco Olarte. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general