The seconds and time zones

[Jim Ault]

On Jan 26, 2010, at 8:07 PM, Monte Goulding wrote:

> Hi Folks
>
> There is another issue when using the seconds for a time stamp. If  
> you record the seconds in a month outside summer time and translate  
> the seconds to another format in a month in summer time or visa  
> versa your result is an hour wrong. So the engine is not working out  
> if the date the seconds refers to is in summer time or not before  
> converting it using your local time zone. I always use the internet  
> time for time stamps.
>

Agreed, especially if you are populating a database that would depend  
on accurate time stamps such as system log files for data processing  
and work flows.  Reports and comparisons can span months.

Most comparisons are not that stringent, so the seconds will work fine.

Jim Ault
Las Vegas