Re: Sybase patches for Daylight Saving Time (DST)


ZeldorBlat wrote:
Ray wrote:
Does anyone know whether Sybase has released any DST patches for Sybase
ASE ?

DST has nothing to do with Sybase. The operating system keeps track of
the time, and Sybase asks the OS when necessary.

Actually, you may need to consider DST in ASE. If you are running
ASE such that it is affected by daylight savings time, then the
datediff() command output will be incorrect in some cases - if you
depend on it being accurate, you need to add logic to correct for
differences due to DST between the two values.

Personally, I think it is a mistake to run ASE under DST; far better to
run it under coordinated universal time and let clients be responsible
for any translations to local time zones. Not only does this eliminate
the datediff issues, but no changes are required if management decides
to move the company headquarters to someplace in a different time
zone. :-}

-bret

.