SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Simple Date conversion to DD/MM/YYYY

22f92271-5bf8-4e69-bf65-d13c56daab6aDec 8 2015 — edited Dec 9 2015

Hi,

I don't have much SQL experience as you may guess by my question. But I'm unable to find a simple answer anywhere

I run a simple select query of

Select [column_name] from [table]

and get the result of "2015-10-01 13:42:16.0"

All I want to do is have this result returned to me in a DD/MM/YYYY format.

It all sounds too easy but I can't find the answer anwhere.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2016

Added on Dec 8 2015

3 comments

6,923 views