Demantra Solutions - EBS (MOSC)

MOSC Banner

In SQL, how to extract date format used for all worksheets?

edited Feb 6, 2013 11:50PM in Demantra Solutions - EBS (MOSC) 3 commentsAnswered ✓
Hi

I want to run a SQL script to extract Date Format used in all worksheets.

Currently, some worksheets are using MM/DD/YY, some ws are using MMM YY.

I want to standardize the date format to MMM YY for all ws. Do you have the SQL script?

FYI, the navigation path to get the date format is Worksheet Time filter --> Advanced button --> Advanced Time Settings window --> Date Format.

Thank you

Regards

Teik Thean

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center