Learn Oracle Applications Tech-Stack
Pages
(Move to ...)
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
▼
Pages
(Move to ...)
Home
Quiz
Workflow
Reports
Form Personalization
Quick Reference API
Fusion Quick Ref SQL
OAF
ADF
WedADI
Concurrent Programs
FNDLOAD
Debugging
▼
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
‹
›
Home
View web version
No comments:
Post a Comment