Skip site navigation (1) Skip section navigation (2)

Re: time stamp

From: Felipe Nascimento <Felipe(dot)Nascimento(at)multivalor(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: time stamp
Date: 2002-06-20 18:31:39
Message-ID: A1D265B81E168745B876193655F97F8D4BFA92@mvescexc01.esc.multivalor.com.br (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Chad R. LarsonDate: 2002-06-20 20:18:07
Subject: Re: really important
Previous:From: Tom LaneDate: 2002-06-20 16:48:37
Subject: Re: time stamp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group