How do I read data from a PostGRESQL timetz field?

Post Author: RobR

CA Forum: Formula

Greetings!

I am using CR XI under Windows XP Pro to report data contained in a PostGRESQL 8.1 database. I need to report data from a field that is declared to be of type timetz (time with time zone). I've tried reading the data into a DateTimeVar variable, a DateVar variable and a TimeVar variable, and in all cases CR tells me that the date I'm reading is not of the correct type. I tried reading it into a StringVar variable and was surprised to see that I did not get an error, but I also didn't get any data. My formula returned "!" + myStringVar + "!", and the only thing that appeared on the report was "!

RobR