[carnation]

When I use PlSQL to select Date data, I always get the data with "dd-mon-yyyy" format. But I want to display data with "dd/mm/yyyy" format.
How can I do that.
Thanks for help.

[Shurik12]

Quote:

---

Originally Posted by carnation
When I use PlSQL to select Date data, I always get the data with "dd-mon-yyyy" format. But I want to display data with "dd/mm/yyyy" format.
How can I do that.
Thanks for help.

---

Hi,

Try

To_Date( 'What_you_wan_to_convert', 'dd/mm/yyyy')


Shurik.

[carnation]

Is there anywhere in Oracle allow us to set the date format?

[alimo]

Quote:

---

Originally Posted by carnation
Is there anywhere in Oracle allow us to set the date format?

---

YES AT SESSION LEVEL:=

ALTER SESSION
SET NLS_DATE_FORMAT = 'DD/MM/YYYY'

HOPE IT HELPS

[Kashif]

there is an othere method to Set its Date Fomat.

Open Regedit. and open this Key

HK_LOCAL_MACHINE>SOFTWARE>ORACLE
Create a new Key and rename to NLS_DATE_FORMAT

then Modyfy its Value DD/MM/YYYY

it will change the Date Format just for Oracle. you dont have to need to Set its format at every Session.....