Learn Oracle Applications Tech-Stack
Pages
Home
SOA
Fusion BI Reporting
Fusion BI Reports SQL
Fusion Quick Ref SQL
OAF
WedADI
Workflow
Reports
Debugging
FNDLOAD
Concurrent Programs
Quick Reference API
Form Personalization
Quiz
Tuesday, 20 November 2018
Convert Date Time to Another Timezone
SELECT
to_char(
CAST(
(
FROM_TZ(CAST(sysdate AS TIMESTAMP),'GMT')
AT TIME ZONE 'Asia/Dubai'
) AS DATE)
,'HH:MI PM')
Asia_Dubai
FROM
dual
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment