I think you need to use to_timestamp(text, text) to convert the date in string format to a timestamp w/ a timezone see PostgreSQL: Documentation: 8.4: Data Type Formatting Functions
I think you need to use to_timestamp(text, text) to convert the date in string format to a timestamp w/ a timezone see PostgreSQL: Documentation: 8.4: Data Type Formatting Functions