qucik timestamp questions

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: qucik timestamp questions
Date: 2005-08-01 17:18:17
Message-ID: 20050801171817.7292.qmail@web33310.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

i read through the manual and googled, but i couldn't
find the answer to the following questions...

if i insert now() into a timestamp field, will it
insert the local time or the gmt time? i think it is
the local time, but i want to be sure before i set up
my table.

is the only reason for selection "timestamp with time
zone" to be able to display the time zone in the
future?

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-08-01 17:29:17 timestamp timezone problem
Previous Message Jessica Ditt 2005-07-31 09:39:57 max length of returned cstring