time zone on timestamp fields

From: maillist <maillist(at)tnss(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: time zone on timestamp fields
Date: 2003-08-01 02:41:30
Message-ID: 3F29D35A.7726F6D4@tnss.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ok me dumb, I've spend copple days editing my table definintions from
Dlm DATETIME NOT NULL DEFAULT TEXT 'now'
Dlm = date time last modified to
Dlm timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP

which from my previous post I was told should be
Dlm timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP

now some where along the line I expect to get asked what time zone, and
I don't want my stupid programs to have to me time zone aware, Back in
the good ol days I could use someting like cst5cdt, but I don't think
that will work any more. and since the postgres programers who I am
grateful to, don't want to code this politicly controled stuff either,
their documentation reflects this. and realy this makes no difference to
me either except in one one in october from 2:00 am to 2:00 am. But
before I go back and change the 100 so table defenitions again, and
change the ones I haven't made it to yet could someone please give me a
quick and dirty explaination as to what I should change it to, and If
you want to elaberate on why, I'll consider it a plus.

Thanks in advance
Arno

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-08-01 03:56:09 Re: Recall: help needed for performance tuning
Previous Message Tom Lane 2003-08-01 00:38:02 Re: Stuck Spinlock Error Message