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:   16-11-04 23:38

AnotherJunkMale wrote:

> When I have had to do similar things before I have always
> preferred to use UTC and store date/time values as a time_t
> value and do any needed conversions upon use.

time_t? FreshPorts stores everything in a PostgreSQL database. At present, it uses a timestamp with time zone. That started in the days when commits were done in PST and my machine was in EST. I thought it best to store the timezone information. It was easier than converting to UTC, or so I thought.

> Another idea is to run the server or process in UTC instead of
> PST/PDT.

I think I may leave the server in PST but change the database field to be without a timezone. The input data is already in UTC, so all I need to do is strip away the timezone and we're done.

I think that idea most because it allows me to let the user specify the time adjustment value themselves, thereby converting UTC to the time of their preference.

 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.