Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Timezone convertor- Using Oracle FROM_TZ function

500237Jan 13 2011 — edited Jan 13 2011
Hi All,

I am trying to understand the following SQL statement written in the code I am reading but could not make out how to divide it into seperate pieces to understand what is happening at which stage.

This is the query
select TO_CHAR(FROM_TZ(CAST(TO_DATE(fsh.start_time, 'DD/MM/YY') AS
                            TIMESTAMP),
                       'Europe/London') AT TIME ZONE 'Asia/Singapore',
               'hh24:mi:ss')
  from feed_status_history fsh
I am told that it converts the ''Europe/London' time zone to 'Asia/Singapore' zone but I am not able to make out how is it taking place. The actual problem is that I am not understanding what this "AT TIME ZONE" thing does ?

Please help me to understand the meaning of this query and how it might be working for FROM_TZ, CAST etc.

Thanks,
Aashish
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2011
Added on Jan 13 2011
10 comments
3,071 views