with z as ( select distinct tn.tzname as "timezone", cast( from_tz( cast(sysdate as timestamp), dbtimezone ) at time zone tn.tzname as date ) as "time there" from V$TIMEZONE_NAMES tn ) select "time there", listagg("timezone", ', ') within group (order by "timezone") as "where" from z group by "time there" order by "time there"
Archive for September, 2011
world clock
Posted by Matthias Rogel on 28. September 2011
Posted in sql | Leave a Comment »