Re: [Sqlrelay-discussion] US Daylight savings update in 2007

[David M. <dav...@fi...>]

Now that I think about it...

SQL Relay does have a few timeouts.  They use the number of seconds
since 1970 as a basis though, or the alarm() system call, so neither
should be affected by a transition into or out of daylight savings time.

There is also a debug mode where time/date is printed out in a file with
each debug message.  If the OS fails to set the clock ahead or behind
because it hasn't been updated to calculate daylight savings time per
the new standard, then those messages may not show the right time, but
in that case, the rest of the system would be off too.

On Mon, 2007-02-05 at 08:52 -0500, Francis Fauteux wrote:
> Here's the reply I got from James K. Lowden regarding FreeTDS:
> > FreeTDS knows nothing of time zones or the zoneinfo files.  It gets
> the 
> > local time from the OS for logging and timeout purposes.  The
> intention is 
> > that even if your query timeout crosses a localtime change boundary or
> the 
> > admin resets the clock, the timeout will continue to work as intended
> by 
> > the application. 
> > HTH. 
> > --jkl
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...] On Behalf Of
> David Muse
> Sent: Friday, February 02, 2007 3:50 PM
> To: Discussion of topics related to SQL Relay
> Subject: Re: [Sqlrelay-discussion] US Daylight savings update in 2007
> 
> To my knowledge, SQL Relay doesn't contain any code that does anything
> timezone-related.  There are very few places in the code where any
> date/time related functions are called at all and they don't appear to
> be time-zone-dependent.  It's possible that freetds does though.   SQL
> Relay uses the freetds library to connect to SQL Server.  It's also
> possible that the PHP, Python, Perl, etc. API's that SQL Relay
> interfaces with do, so you may want to check into whichever of those
> that you use.
> 
> Take care,
> 
> Dave
> 
> On Fri, 2007-02-02 at 15:03 -0500, Francis Fauteux wrote:
> > Good day,
> > 
> > We are using SQL relay to access MS SQL Server from a Red Hat 8
> > machine. We need to upgrade our system in preparation of the US
> > daylight savings update of 2007
> >
> (http://en.wikipedia.org/wiki/Energy_Policy_Act_of_2005#Change_to_daylig
> ht_saving_time).
> > 
> > I suspect that SQL relay gathers time zone information (if any) from
> > the OS (/usr/share/zoneinfo, see
> > http://www.twinsun.com/tz/tz-link.htm), but I need confirmation before
> > considering this issue classified.
> > 
> > Thanks for your input.
> > 
> > Francis
> > 
> > 
> > 
> > ______________________________________________________________________
> > This email has been scanned by the MessageLabs Email Security System.
> > For more information please visit http://www.messagelabs.com/email 
> > ______________________________________________________________________
> >
> ------------------------------------------------------------------------
> -
> > Using Tomcat but need to do more? Need to support web services,
> security?
> > Get stuff done quickly with pre-integrated technology to make your job
> easier.
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> >
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________ Sqlrelay-discussion
> mailing list Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> ------------------------------------------------------------------------
> -
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email 
> ______________________________________________________________________
> 
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email 
> ______________________________________________________________________
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>