Daylight savings time issue

[GregJWillis]

I am running into a Daylight savings time issue:

The SYSTEM view has the default timezone field where it suggest EST, CST, PST...etc.
You can enter anything as it is a text field. And this is ok. You put in the default and this works for "S" standatd time zones. Any user record that has the time zone selected as the "System Defualt" uses this value in "Standard" time zones.

The problem is if it is Daylight Savings. The times displayed on any date field shows an hour earlier.

I tried changing the default SYSTEM value to EDT, but this causes all dates to be displayed in GMT...so this is obviouly a bad entry recognized in the field (just like if you enter gibberish in that field).

So I went to my user record and manually changed the time zone to "Eastern" and this did display the correct daylight option.

Does this mean we should change all the user record's time zone options to their appropriate selections to show the appropriate time zones?

Is this just a glitch in the SYSTEM variable option not playing nice in Daylight time?

(and don't forget to logout after each change when testing this...)

[marcguy]

For an instance in the UK I would use the format Europe/London

maybe try that for whatever timezone you want to be the default.

[GregJWillis]

Absolute genious! The help text says EST, CST, PST...but I never tried "US/Eastern" in the SYSTEM record's default field.

It works perfectly. Many thanks! Now user records can use the default option and that sets the correct time.

[john_roberts]

We should probably make the system time zone property a choice list. Until then you can access the list of all possible time zones (more than you think) by viewing the choices on the sys_user time_zone field.

[GregJWillis]

Yep, and that is what I did...I made sure it was the same as the user record's choices.