select to_char(to_date(sysdate,'dd-mon-rr'),'dd/mon/yyyy

26. Display the earliest shipping date in the format:
DD/MON/YYYY

Question Posted / uday shankar chejerla

Answer Posted / uday shankar chejerla

select to_char(to_date(sysdate,'dd-mon-rr'),'dd/mon/yyyy')
from dual;

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between a hot backup and a cold backup in oracle?

1017

How to recover a dropped table in oracle?

1048

How to list all user accounts in oracle?

1028

When do you get a .pll extension in oracle?

1146

What is the difference between pre-select and pre-query?

1221

what are actual and formal parameters?

1104

What is a procedure in oracle?

1199

What are group functions in oracle?

1042

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2186

How to define a sub function?

1134

What is a cursor variable?

1132

Explain database link?

1126

how to handle exceptions in post production

1427

What is rowid and rownum in oracle?

1011

What is a relational database management system?

1120