Translating line from sql server to oracle

Question

I am slightly confused with the way to_char works in oracle. How would you translate this sql server line into oracle?

cast(month(date) as varchar)+'/'+cast(day(date) as varchar)+'/'+cast(year(date) as varchar)

Your title says translate from oracle to sql server and your question says translate from sql server to oracle. Which is it? — Siyual
– Siyual, Commented May 10, 2016 at 12:40

Pham X. Bach · Accepted Answer · 2016-05-10 13:48:59Z

6

Just use this:

select to_char(date_column,'MM/dd/yyyy') from your_table;

You should read more about to_char in oracle docs or techonthenet. You will find it easy to understand.

answered May 10, 2016 at 12:51

Pham X. Bach

5,4624 gold badges32 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hum I had been messing up on something quite silly. Thank you