Sunday, July 14, 2019

To Alter Date Format in SQL Developer

alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS'

Note: By Default is YYYY-MM-DD
Change to : Date & Time format'

Alternate way by updating SQL Developer setting as mentioned below


No comments:

Post a Comment

Popular Posts