Skip site navigation (1) Skip section navigation (2)

Time is off in PG server

From: Ericson Smith <eric(at)did-it(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Time is off in PG server
Date: 2004-08-26 13:47:26
Message-ID: 412DE9EE.1070207@did-it.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

When using date oriented functions on Postgresql, the time is an hour 
off, or in certain times, one hour ahead.

System Timezone: EST
System Time (date command): Thu Aug 26 09:44:28 EDT 2004
SELECT now(); : 2004-08-26 08:44:31.307343-05
SELECT date_part('epoch', '2004-08-26'::timestamp) ; : 1093496400 (1am 
on that day -- should be 12pm)

Any suggestions?

-- 
Warmest regards, 
Ericson Smith
Tracking Specialist/DBA
+-----------------------+------------------------------+
| http://www.did-it.com | Need help tracking your paid |
| eric(at)did-it(dot)com       | search campaigns?            |
| 516-255-0500          |        - Help is on the way! |
+-----------------------+------------------------------+ 


Attachment: eric.vcf
Description: text/x-vcard (315 bytes)

Responses

pgsql-admin by date

Next:From: Jay A. KreibichDate: 2004-08-26 14:38:18
Subject: Re: Time is off in PG server
Previous:From: Kieran McCuskerDate: 2004-08-26 13:28:17
Subject: Loading functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group