Link to home
Start Free TrialLog in
Avatar of ali şahin
ali şahin

asked on

how to alter date format?

I enter the date value in this format.
oracle gives me
 ORA-01843: not a valid month error.
NOTE:(you can better understand the question in the pictures.
Please see the pictures.User generated image
but
I enter the date value in this format.
Oracle is running.
User generated image)
I want to change the date format.
I don't want to use this date (13.jun.2014),
 I want to use this date = (13.06.2014),
how can I do this?

Result of query 'select sysdate from dual'
17/09/2019 17:46:00

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ali şahin
ali şahin

ASKER

thanks a lot :)