Link to home
Create AccountLog in
Avatar of sam2929
sam2929

asked on

Correct date format in sql developer

Hi,
I have date_created datatype date showing in sql developer as 06-09-29 can I display it in yyyy-mm-dd format.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of sam2929
sam2929

ASKER

I did alter session now date coming like 006-10-09
You apparently missed a "y".  You need four of them as sdstuber suggested.  You apparently executed this (with just three "y" characters):

alter session set nls_date_format='yyy-mm-dd';

Correct version is:
alter session set nls_date_format='yyyy-mm-dd';