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

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

Question Posted / nazim

Answer Posted / nazim

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the oracle built-in data types?

1001

How to drop a stored function?

1082

What is ASM (Automatic Storage Management) in Oracle?

1120

What are the system predefined user roles?

980

Explain what are the type of synonyms?

1052

How to use existing values in update statements using oracle?

1009

What is format trigger?

2009

How to empty your oracle recycle bin?

979

How does oracle handle read consistency?

1049

How to delete a user account in oracle?

910

What are dml statements in oracle?

1039

How to name query output columns in oracle?

1129

What is set operator oracle?

919

What are operators in oracle?

1008

Explain temporal data types in oracle

1039