Re: time stamp

Interesting point.

Original Message dated 21/06/02, 4:31:39
Author: Felipe Nascimento <Felipe(dot)Nascimento(at)multivalor(dot)com(dot)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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: quinta-feira, 20 de junho de 2002 13:49
To: nimeshb
Cc: Brian McCane; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] time stamp

"nimeshb" <nimeshb(at)syscon-intl(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly