Results 1 to 4 of 4

Thread: Timezone

  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: Timezone

    Setup: Forms 9i, DB 9i, W2K

    In my form GET_APPLCATION_PROPERTY(DATETIME_LOCAL_TZ) returns 'GMT'. According to the documentation I should be able to use the environmental variable FORMS90_DATETIME_LOCAL_TZ but I do not want to hard code a value (ie CST) when the value will need to be changed every time daylight savings comes in or out. In addition when I have tried to set the value I have either received errors or it did not change anything.

    Anyone run into this problem?
    NOTE: Please disregard the label "Senior Member".

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    Todd, help me to HELP YOU.

    Please explain again what you want to do with the GMT date/time.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    I want to display the timezone on the screen. The requirement doc states that dates are formatted 'HH24:MI TZ'.

    All I really need is the timezone in character version, I really do not care where I get it. I am currently hard coding TZ='CST'. There are plans to ship the application to Ireland at some point, an my system will break. Not to mention that CDT is just around the corner.
    NOTE: Please disregard the label "Senior Member".

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    painful!

    I grab the timezone from the server-side (Solaris).
    date +'%Z'

    I pass this in to the new_time field in order to change EST, EDT to GMT and visa-versa

    v$timezone_names has a list ... that probably does not help you though.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •