Bottom quoting makes it difficult to reply properly, so reformated a bit: On Thu, Oct 20, 2016 at 2:02 PM, William Ivanski <william.ivanski@xxxxxxxxx> wrote: > Em qui, 20 de out de 2016 às 09:52, Bjørn T Johansen <btj@xxxxxxxxxx> > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
