"Anibal David Acosta" <aa@xxxxxxxxxxxx> writes: > Because I need to get all rows where datetime is greater than (for example) > '2012-10-10 00:00:00' but ignoring timezone, so basically I need to truncate > timezone > This can be done by converting to timestamp without timezone. [ shrug... ] It can also be done without that. Whatever your cutoff time is can be expressed as a timestamp *with* tz. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
