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

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

Question Posted / deepakgunji

Answers were Sorted based on User's Feedback

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

select to_char(sysdate,'DD/MON/YYYY') from dual;

Is This Answer Correct ?

4 Yes

2 No

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

Answer / 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

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

Answer / panchi

dd/mm/yyyy

Is This Answer Correct ?

4 Yes

3 No

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

Answer / bhanu

select to_char(sysdate,'DD/MON/YYYY') from dual;

Is This Answer Correct ?

2 Yes

2 No

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

Answer / nazim

select convert(char(12),getdate(),106)

Is This Answer Correct ?

0 Yes

1 No