[pguser]

Zitat von DoubleF

Also wenn meine Abfrage so aussieht

PHP-Code:

$sql = mysql_query("SELECT news_date FROM news"); 


wie müsste die dann aussehen?

Ist das sooo schwer?

test=*# create table doublef (news_date timestamp);
CREATE TABLE
test=*# insert into doublef values (now());
INSERT 0 1
test=*# select news_date at time zone 'utc' from doublef ;
           timezone
-------------------------------
 2014-08-06 17:56:00.726007+02
(1 row)

test=*# select news_date at time zone 'cdt' from doublef ;
           timezone
-------------------------------
 2014-08-06 22:56:00.726007+02
(1 row)