FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

I am looking for an LTO tape library. Do you have one to spare?
Website Feedback
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Previous Message  |  Next Message 
 Re: Timezones
Author: Dan 
Date:   14-11-04 13:43

AnotherJunkMale wrote:

> JunkMale wrote:
>
> > - commit times not being displayed in local time
>
> Or even just document the server timezone (or use UTC).
>
> Currently the times being displayed are one hour off of UTC.

They are now UTC. The one hour off was because of daylight savings.

This issue is not as simple to resolve as it may seem.

Try it yourself.

Create a PostgreSQL database. Dates are stored in a 'timestamp with time zone' field. Ensure your system time zone is set to PST.

dan=# insert into test values ('2004-11-14 13:07:23 UTC');
INSERT 8834308 1
dan=# select * from test;
commit_date
------------------------
2004-11-14 05:07:23-08
(1 row)

dan=# insert into test values ('2004-11-14 13:07:23');
INSERT 8834318 1
dan=# select * from test;
commit_date
------------------------
2004-11-14 05:07:23-08
2004-11-14 13:07:23-08
(2 rows)

The system uses a time_adjust feature. It was set at -7 hours. It is now set at -8 hours.

A possible solution might be to remove the time zone from such fields and just store the time as found in the commit message. Such a solution removes flexibility.

As before, I am open to suggested solutioned.

 Reply To This Message  |  Forum List  |  Flat View   Newer Topic  |  Older Topic 

 Topics Author  Date
 Timezones   new
andy 21-05-03 09:32 
 Re: Timezones   new
JunkMale 21-05-03 11:10 
 Re: Timezones   new
andy 22-05-03 06:48 
 Re: Timezones   new
andy 22-05-03 06:52 
 Re: Timezones   new
JunkMale 22-05-03 10:51 
 Re: Timezones   new
AnotherJunkMale 14-11-04 06:15 
 Re: Timezones   new
Dan 14-11-04 13:43 
 Re: Timezones   new
AnotherJunkMale 14-11-04 19:51 
 Re: Timezones   new
Dan 14-11-04 21:01 
 Re: Timezones   new
Dan 16-11-04 23:38 
 Re: Timezones   new
Dan 17-11-04 00:57 
 Re: Timezones   new
Dan 17-11-04 03:26 


 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.


Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2014 Dan Langille. All rights reserved.