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