how to add timezone in standard way

[Community Alums]

i have added some timezones to SYS_USER table but they are not working properly

by default system has some timezones and UTC-5 US/Eastern Time is one of them this is working fine but i added UTC+530 India Time, and that is not working . can you plz let me know what is standard way to write timezones or any standard way to do this.

[Chuck Tomasi]

If you want to add it to the choice list, you can. Instead of Configure Choices, use Show Choices.

Add the entry like this:

[Community Alums]

thanks , but one things how WRITING IST will automatically calculate this , is there some back coding from where it will match its value to utc+5:30 ?

[Chuck Tomasi]

My understanding is that it gets it from the OS (or some shared library at the filesystem/OS level.)