Database Administration (MOSC)

MOSC Banner

how to make it the same

Hi all,

In the database it is  "23-11-12 11:38:16.931620 AMERICA/NEW_YORK", but on my laptop is showing as 2023-11-12T07:38:16-04:00

I would like on my laptop the values is showing as that on database "america/new_york"

checked on NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH:MI:SS. FF TZH:TZM', ←- will give -4:00, but I want america/new_york

Please help. Appreciated!

Friendly

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center