René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

tz_offset in Oracle

select tz_offset('Asia/Singapore') from dual;
See also dbtimezone.