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

Website Feedback
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Previous Message  |  Next Message 
 Re: Timezones
Author: AnotherJunkMale 
Date:   14-11-04 19:51

Dan wrote:

> This issue is not as simple to resolve as it may seem.
> 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.

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.

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

These are just ideas for consideration, often there are more complexities involved, especially if you are using features of the date data types.

One place I worked once, a VP insisted on using Eastern Time for some reports and I needed to send a reminder email out twice a year explaining why April would have one day with 4% less usages and October would show one day with 4% extra usage.

 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:
 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-2018 Dan Langille. All rights reserved.