Oracle Database Discussions

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!

Query to Convert EST/PST//MST.. to IST

549770Jul 24 2007 — edited Jul 24 2007

Hi,
I have a requirement where in i need to capture the task assigned by any client (located in US/UK) to our local DBA team and schedule the task and alert the DBA resource to attend the task at local timezone..

Hence I need to convert the timezone(EST/PST..) to IST

I tried new_time() function,but it doesn't support IST timezone..

Kindly suggest any other solution which is appropriate

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 21 2007

Added on Jul 24 2007

#general-database-discussions

3 comments

925 views