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-21 14:25:52
Message-ID: A1D265B81E168745B876193655F97F8D4BFAAF@mvescexc01.esc.multivalor.com.br (view raw or flat)
Thread:
Lists: pgsql-admin
Anybody???

  _____  





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 <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: Luis Andaluz P,Date: 2002-06-21 14:57:20
Subject: Incredible..
Previous:From: Tom LaneDate: 2002-06-21 14:25:34
Subject: Re: lost superuser perms

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