Forum Stats

  • 3,769,920 Users
  • 2,253,030 Discussions
  • 7,875,240 Comments

Discussions

Wrong timezone reported to DB

Mike Kutz
Mike Kutz Member Posts: 5,819 Silver Crown

I'm sure this is a problem with the browser only. I hope someone can help.

Firefox Mobile is reporting the wrong timezone to APEX.

Edge Mobile reports correctly. Both Firefox PC and Edge PC report correctly.

Web search says "turn fingerprint off". I don't see how. I tried what I thought would work (will retest). but that didn't work.

Also, the website suggest that the time zone that will be report is UTC +0. Mine is reporting 1 hr off (-4 instead of -5).

How do I fix? (my google fu is lacking)

Thanks

MK

Best Answer

  • Mike Kutz
    Mike Kutz Member Posts: 5,819 Silver Crown
    edited Oct 30, 2021 1:26PM Accepted Answer

    SOLVED

    steps to find

    1. turn on debug(*)
    2. noticed log-out-login set the correct timezone
    3. discovered problem with bookmark

    Turn on debug

    I modified the Session Initialize PL/SQL code to run apex_debug.enable for my test user.

    I also reported (in debug) what the SESSIONTIMEZONE was.

    Bookmark

    The book mark had a &tz_??=-5:00 (I forgot actual parameter name) at the end. This was the time zone that was constantly reported.

    Next time, I'll try to figure out how those bookmarks are created with the specific timezone.

    Hopefully, this helps someone.

    MK

Answers

  • Mike Kutz
    Mike Kutz Member Posts: 5,819 Silver Crown
    edited Oct 30, 2021 1:26PM Accepted Answer

    SOLVED

    steps to find

    1. turn on debug(*)
    2. noticed log-out-login set the correct timezone
    3. discovered problem with bookmark

    Turn on debug

    I modified the Session Initialize PL/SQL code to run apex_debug.enable for my test user.

    I also reported (in debug) what the SESSIONTIMEZONE was.

    Bookmark

    The book mark had a &tz_??=-5:00 (I forgot actual parameter name) at the end. This was the time zone that was constantly reported.

    Next time, I'll try to figure out how those bookmarks are created with the specific timezone.

    Hopefully, this helps someone.

    MK