Timestamp + Interval time zone issues

2010-07-28 Thread Mike Ginsburg
So I have pg 8.4.3 installed, with a database set to EST5EDT time zone. When I run SELECT NOW() I get 07/28/2010 14:27:07.767286 EDT showing that the timezone is properly set up. When I then try to add an interval to a statically entered time stamp, it gets all strange: SELECT '01/03/2011 16

Re: Timestamp + Interval time zone issues

2010-07-28 Thread Chuck Swiger
Hi-- On Jul 28, 2010, at 11:28 AM, Mike Ginsburg wrote: When I then try to add an interval to a statically entered time stamp, it gets all strange: SELECT '01/03/2011 16:00:00-04'::timestamp with time zone + '-1 hour'::interval; ?column?- 01/03/2011

Re: Timestamp + Interval time zone issues

2010-07-28 Thread Jon Radel
On 7/28/10 2:28 PM, Mike Ginsburg wrote: So I have pg 8.4.3 installed, with a database set to EST5EDT time zone. When I run SELECT NOW() I get 07/28/2010 14:27:07.767286 EDT showing that the timezone is properly set up. When I then try to add an interval to a statically entered time stamp

Re: Timestamp + Interval time zone issues

2010-07-28 Thread Mike Ginsburg
Jon Radel wrote: On 7/28/10 2:28 PM, Mike Ginsburg wrote: So I have pg 8.4.3 installed, with a database set to EST5EDT time zone. When I run SELECT NOW() I get 07/28/2010 14:27:07.767286 EDT showing that the timezone is properly set up. When I then try to add an interval to a statically

Squirrel Mail Time Zone Errors

2010-07-10 Thread Chris Maness
Is anyone getting these errors when logging in to Squirrel Mail? Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those

Re: Squirrel Mail Time Zone Errors

2010-07-10 Thread Amitabh Kant
the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /usr/local/www/squirrelmail/functions/date.php on line 289 These things go on forever in the in box. Thanks, Chris Maness Have you recently upgraded to php 5.3 recently? You might need to set the time

Re: Squirrel Mail Time Zone Errors

2010-07-10 Thread Chris Maness
Have you recently upgraded to php 5.3 recently? You might need to set the time zone either in php.ini file or set the same on the script page at the top using date_default_timezone_set('America/Los_Angeles'); Amitabh Kant Instant fix. Thank You. Chris Maness

How to make a process detect time zone change?

2010-03-16 Thread Peter Steele
We have a system controlled through a Java GUI and one of the commands provided in the GUI is to change the date/time, including the time zone. When the time zone is changed the FreeBSD system immediately recognizes the change (that is, the date command from the command line shows the correct

Re: How to make a process detect time zone change?

2010-03-16 Thread Mark Shroyer
On 3/16/2010 11:23 AM, Peter Steele wrote: We have a system controlled through a Java GUI and one of the commands provided in the GUI is to change the date/time, including the time zone. When the time zone is changed the FreeBSD system immediately recognizes the change (that is, the date

How is time zone change signalled?

2009-08-07 Thread Peter Steele
We have a suite of applications with a Java GUI controlling everything. One of the actions the user can perform is to set the time zone. We do this through our Java application and update the /etc/localtime as required. We also make an API call to tell the JVM that the time zone as changed

Re: How is time zone change signalled?

2009-08-07 Thread Greg Larkin
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter Steele wrote: [...] The problem is with our C applications. They continue to operate with the old time zone, so things like timestamps in log files are not in sync with the timestamps in the Java app log files. If we stop and restart

RE: How is time zone change signalled?

2009-08-07 Thread Peter Steele
be completely off-base! Yes, I've tried the tzset function. I'm basically doing the equivalent of these steps after the Java app changes time zone and updates /etc/localtime: time_t date = time(NULL); unsetenv(TZ); tzset(); printf(time zone is %s/%s, tzname[0], tzname[1

Re: How is time zone change signalled?

2009-08-07 Thread Greg Larkin
. I haven't tested it, though, and I'm no timezone expert, so I may be completely off-base! Yes, I've tried the tzset function. I'm basically doing the equivalent of these steps after the Java app changes time zone and updates /etc/localtime: time_t date = time(NULL); unsetenv

RE: How is time zone change signalled?

2009-08-07 Thread Peter Steele
I wonder if you'd get more insight by asking the question in -hackers. Perhaps there are some libc experts listening there. Well, I still haven't found the magic so I'll try my luck there... Thanks for the feedback. ___ freebsd-questions@freebsd.org

EDT time zone change in 2007

2007-01-11 Thread Paul Khavkine
Hi. There's has been changes to how Daylight Saving Time is observed in eastern canada in 2007: http://www.timetemperature.com/tzca/daylight_saving_time_canada.shtml Is there anything that needs to be done to FreeBSD to reflect the changes ? Thanx Paul

Re: Time zone isn't displaying right one with 'tzsetup'

2006-08-23 Thread Matthew Seaman
jdow wrote: From: Robert Gabaree [EMAIL PROTECTED] I tried to update my new server to the new time zone by running 'tzsetup' and selecting Eastern. However, instead of showing 11:45, it shows 6:45 - 5 hours later. I even tried to do a 'cp /usr/share/ zoneinfo/EST5EDT /etc/localtime

Re: Time zone isn't displaying right one with 'tzsetup'

2006-08-23 Thread Pete Slagle
Greg 'groggy' Lehey wrote: On Tuesday, 22 August 2006 at 23:45:19 -0400, Robert Gabaree wrote: Hi, I tried to update my new server to the new time zone by running 'tzsetup' and selecting Eastern. However, instead of showing 11:45, it shows 6:45 - 5 hours later. I even tried to do a 'cp

Time zone isn't displaying right one with 'tzsetup'

2006-08-22 Thread Robert Gabaree
Hi, I tried to update my new server to the new time zone by running 'tzsetup' and selecting Eastern. However, instead of showing 11:45, it shows 6:45 - 5 hours later. I even tried to do a 'cp /usr/share/ zoneinfo/EST5EDT /etc/localtime but it didn't help. What can I do to fix

Re: Time zone isn't displaying right one with 'tzsetup'

2006-08-22 Thread Greg 'groggy' Lehey
On Tuesday, 22 August 2006 at 23:45:19 -0400, Robert Gabaree wrote: Hi, I tried to update my new server to the new time zone by running 'tzsetup' and selecting Eastern. However, instead of showing 11:45, it shows 6:45 - 5 hours later. I even tried to do a 'cp /usr/share/ zoneinfo/EST5EDT

Re: Time zone isn't displaying right one with 'tzsetup'

2006-08-22 Thread jdow
From: Robert Gabaree [EMAIL PROTECTED] Hi, I tried to update my new server to the new time zone by running 'tzsetup' and selecting Eastern. However, instead of showing 11:45, it shows 6:45 - 5 hours later. I even tried to do a 'cp /usr/share/ zoneinfo/EST5EDT /etc/localtime

RE: How to Change the Time Zone Rules?

2006-07-30 Thread Murray Taylor
Of Carlos A. Carnero Delgado Sent: Saturday, 29 July 2006 1:20 AM To: Martin McCormick Cc: freebsd-questions@freebsd.org Subject: Re: How to Change the Time Zone Rules? Hello, On 7/28/06, Martin McCormick [EMAIL PROTECTED] wrote: My question is, How do I get there from here? See zic

How to Change the Time Zone Rules?

2006-07-28 Thread Martin McCormick
The rules for determining the yearly start and end of daylight saving time in the United States have changed beginning in March of 2007. All the FreeBSD systems I am in charge of need new rules and I read an article that mentions FreeBSD and Linux and the /usr/share/zoneinfo data base

Re: How to Change the Time Zone Rules?

2006-07-28 Thread Carlos A. Carnero Delgado
Hello, On 7/28/06, Martin McCormick [EMAIL PROTECTED] wrote: My question is, How do I get there from here? See zic(8). It's very easy. Best regards, Carlos. -- nick grah windows just crashed again, unstable crap. yukito Windows isn't unstable, it's just spontaneous.

Re: How to Change the Time Zone Rules?

2006-07-28 Thread Martin McCormick
Carlos A. Carnero Delgado writes: See zic(8). It's very easy. DAve writes: This was sent to me earlier on this list when I had to adjust for Indiana changing to DST. Worked like a champ. https://engineering.purdue.edu/ECN/Resources/KnowledgeBase/Docs/20060128100824 Thank you both.

Re: Time Zone

2006-01-17 Thread Jerry McAllister
What is the prefered time zone for a web server Is it better to keep it GMT or local timezone ? I am in eastern time zone so I need to deal with standard and daily saving time... We keep ours on local time. I think that is the way most do it. jerry Thanks

Re: Time Zone

2006-01-17 Thread Crispy Beef
Ian Lord wrote: What is the prefered time zone for a web server Is it better to keep it GMT or local timezone ? I am in eastern time zone so I need to deal with standard and daily saving time... We are UK based but our server (and most of our customers) are US based, so we keep the US time

Re: Time Zone

2006-01-17 Thread Danny Howard
On Tue, Jan 17, 2006 at 01:32:01AM -0400, Carlos A. Carnero Delgado wrote: On 1/16/06, Ian Lord [EMAIL PROTECTED] wrote: What is the prefered time zone for a web server Is it better to keep it GMT or local timezone ? Both ;) Set the machine's clock to GMT (actually, UTC.) Then set

Time Zone

2006-01-16 Thread Ian Lord
What is the prefered time zone for a web server Is it better to keep it GMT or local timezone ? I am in eastern time zone so I need to deal with standard and daily saving time... Thanks ___ freebsd-questions@freebsd.org mailing list http

Re: Time Zone

2006-01-16 Thread Carlos A. Carnero Delgado
Hello, On 1/16/06, Ian Lord [EMAIL PROTECTED] wrote: What is the prefered time zone for a web server Is it better to keep it GMT or local timezone ? Both ;) Set the machine's clock to GMT (actually, UTC.) Then set the correct timezone for your location. Best regards, Carlos. -- nick grah

Re: FYI: Time zone information update for Cuba

2004-10-26 Thread Carlos A. Carnero Delgado
Hello, Kris Kennaway wrote: the attached diff updates /usr/src/share/zoneinfo/northamerica for this year's unique time handling in Cuba. Wasn't an update already committed to -current? Well, AFAICT, there was a recent commit for Brazil and Argentina data. In any case I think that it was

Re: FYI: Time zone information update for Cuba

2004-10-26 Thread Kris Kennaway
On Tue, Oct 26, 2004 at 02:35:12AM -0400, Carlos A. Carnero Delgado wrote: Hello, Kris Kennaway wrote: the attached diff updates /usr/src/share/zoneinfo/northamerica for this year's unique time handling in Cuba. Wasn't an update already committed to -current? Well, AFAICT, there was a

FYI: Time zone information update for Cuba

2004-10-25 Thread Carlos A. Carnero Delgado
Hi, the attached diff updates /usr/src/share/zoneinfo/northamerica for this year's unique time handling in Cuba. BTW, who is the maintainer of the package that FreeBSD draws this information from? I'd like to send this so that other OSes can have the update. Best regards, Carlos. ---

Re: FYI: Time zone information update for Cuba

2004-10-25 Thread Kris Kennaway
On Mon, Oct 25, 2004 at 10:59:19AM -0400, Carlos A. Carnero Delgado wrote: Hi, the attached diff updates /usr/src/share/zoneinfo/northamerica for this year's unique time handling in Cuba. Wasn't an update already committed to -current? BTW, who is the maintainer of the package that