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

How to assign data of the deleted row to variables?

1115

What is the simplest tool to run commands on oracle servers?

1052

What is raw datatype in oracle?

1207

How to update values in a table in oracle?

1077

What happens to the data files if a tablespace is dropped?

1107

How to count groups returned with the group by clause in oracle?

1122

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1162

What is the data pump import utility?

1074

What is an Oracle index?

1698

How to invoke the data pump export utility?

1251

How to sort the query output in oracle?

1073

How do I manually uninstall oracle client?

1148

How to empty your oracle recycle bin?

1073

what is the use of system.effective.date variable in oracle?

1161

How to compare dates in oracle sql?

1159