Just for information, I have a PostgreSQL server and I'm connecting from a client (both Linux/Ubuntu).

Opening a Query Analyzer window for a PostgreSQL connection, I run the following:

select current_time;

The result somehow returns an hour less than what it should be. I tested on the command line and on two other GUI tools and they both report the correct time, so I'm guessing the results are formatted before displayed, both "Text" and "Grid" report the wrong result. I expected the text result to return unmodified data, so I don't know how the text even returns the incorrect result.

 timetz     
 ----------
 9:46:02 AM

But on the server the following is returned

select current_time;
       timetz       
--------------------
 10:46:20.879262-04
(1 row)

This may be related to the Timezone as EST is -05 except during daylight savings it is -04. I checked for options but found nothing for Timezone, so I tried changing the format of the displayed time and it didn't make a difference. I should note though that running a similar command returned the correct results, it seems to only be when a time is run without a date maybe? Running the below works correctly:

select current_timestamp;

Results:

 now                   
 ---------------------
 6/16/2015 10:46:47 AM