Re: time stamp - Mailing list pgsql-admin

From Aaron Spiteri
Subject Re: time stamp
Date
Msg-id 20020620.23004900@scooby.m1group.com.au
Whole thread Raw
In response to Re: time stamp  (Felipe Nascimento <Felipe.Nascimento@multivalor.com.br>)
List pgsql-admin

Interesting point.


Original Message dated 21/06/02, 4:31:39

Author: Felipe Nascimento <Felipe.Nascimento@multivalor.com.br>

Re: Re: [ADMIN] time stamp :




I used to manage a database without Time Zone. Now I use PG, and this concept of using Time Zone in date data is new to me. I find it intersting, but I have the following doubt:

let's imagine that my server resides in Time Zone(TZ) "-00", and one user resides in TZ "-05". Let´s say that 12p.m. to the user is 3p.m. to the server, on the same day.

Let's say that the user inputs a date for a business meeting: "2002-06-20 12:00:00". The server will save "2002-06-20 12:00:00-00"?? If my application sends an e-mail for the user reminding him of the meeting one hour befor it, the server will send that email at 11 o'clock (server time) that is 2 o'clock to the user, that means, after the meeting.

My question is: how to manage this so I can send the email to the user at his 11 o'clock (8 a.m. server time)???

Tks
Felipe Nascimento



-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: quinta-feira, 20 de junho de 2002 13:49
To: nimeshb
Cc: Brian McCane; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] time stamp



"nimeshb" <nimeshb@syscon-intl.com> writes:
> CREATE TABLE test (ts TIMESTAMP WITHOUT TIME ZONE) ; doesn't work.

Oh?  I get

test72=# CREATE TABLE test (ts TIMESTAMP WITHOUT TIME ZONE) ;
CREATE
test72=# insert into test values(now());
INSERT 803798 1
test72=# insert into test values('2002-02-22 12:34:56');
INSERT 803799 1
test72=# select * from test;
             ts            
----------------------------
 2002-06-20 12:46:47.030269
 2002-02-22 12:34:56
(2 rows)

test72=# select version();
                            version                           
---------------------------------------------------------------
 PostgreSQL 7.2.1 on hppa-hp-hpux10.20, compiled by GCC 2.95.3
(1 row)



                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

pgsql-admin by date:

Previous
From: "Mark McEahern"
Date:
Subject: Re: time stamp
Next
From: Werner Modenbach
Date:
Subject: pg_dumpall in crontab