[Openroad-users] eClient &Timezones-CORRECTION KB415539not KB415439

[Paul White]

Darren wrote:
  I am rostered to start a shift at 7:00 and finish at 15:00, then these
times are static.   If this is in Perth and I view the data in Sydney then I
still want to see that the employee is rostered to start at 7:00 and finish
at 15:00 – not for the times to alter.
Hey Darren, I'm interested, how does mwp calculate the hours worked for a
roster starting at 23:00 and finishing at 7:00
At the end of DST you get either 8 or 9 hours depending on the Timezone
setting. Is the roster aware of the extra hour?

test_interval.sql
select interval('hours',date('06-apr-2008 07:00') - date('05-apr-2008
23:00'))  \p\g

under unix:
II_TIMEZONE_NAME=AUSTRALIA-VICTORIA
export II_TIMEZONE_NAME
sql mwp <test_interval.sql
II_TIMEZONE_NAME=GMT
sql mwp <test_interval.sql


or windows.
set II_TIMEZONE_NAME=AUSTRALIA-VICTORIA
sql mwp::mwp < test_interval.sql
set II_TIMEZONE_NAME=GMT
sql mwp::mwp < test_interval.sql



and Bill wrote:
  Method 1 above does the conversion from a character string to GMT using
the client side II_TIMEZONE_NAME and the II_DATE_FORMAT and also the
II_DATE_CENTURY_BOUNDARY and the Ingres Date in GMT format is passed to the
DBMS server.

  Method 2 and 3 do the conversion from teh character string value at the
DBMS server using  II_TIMEZ..... values passed accross at the session
initiation time.
Can I point out that regardless of the method used, you cannot be sure the
client and server have the same times or timezone rules (O/S and Ingres).
We discovered inconsistencies when we rolled in the recent ingres timezone
patch and missed some PCs.
The application experienced total failure due to output like this:
  sql mwp
  * select first 1 period_end_date from ta_employee_attendance
  * where period_end_date = '31/03/2008 08:00' ;\g
  Executing . .

  period_end_date
  31/03/08 07:00:00

Some might see it as a flaw in ingres net.
There does not seem to be an easy way to avoid this
I guess it is a similar reason why MS Outlook sends me email responses dated
an hour before I send them. :-)

Paul

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20080412/672e7770/attachment.html