"Anibal David Acosta" <aa@devshock.com> 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