Pam Wampler writes:
example:
insert into foo values (3, '12-aug-2001:00:01:01');
insert into foo values (4,now());
showaltb=> select * from foo;
n | t
---+------------------------
3 | 2001-08-12 00:01:01-04
4 | 2002-02-20 08:59:56-05
Looks fine to me. -05 is EST, -04 is EDT ... and I'd expect
daylight-savings time to be used in August ...

If you don't want daylight-savings time to be used, set your
TimeZone variable to something like "EST", not "ESTEDT" (the
exact form of timezone specs tends to vary across Unixen, so
you'll have to experiment or read the manual to find out what
to use).

regards, tom lane

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 3 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedFeb 20, '02 at 2:25p
activeFeb 20, '02 at 3:30p
posts3
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Pam Wampler: 2 posts Tom Lane: 1 post

People

Translate

site design / logo © 2022 Grokbase