| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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 | Content-Type | Size |
|---|---|---|
| eric.vcf | text/x-vcard | 315 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jay A. Kreibich | 2004-08-26 14:38:18 | Re: Time is off in PG server |
| Previous Message | Kieran McCusker | 2004-08-26 13:28:17 | Loading functions |