When I create a table & insert records, I am getting the wrong timezone info
(-04)
When I insert using now() -- the timezone is right (-05)
I am on EST. Please help --

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

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 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