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

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

Question Posted / nazim

5 Answers
8163 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / nazim

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

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How does oracle handle read consistency?

1097

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

1077

What is the data type of dual table?

995

Explain oracle’s system global area (sga).

1139

What are the differences between interval year to month and interval day to second?

1028

What is a sub query and what are the different types of subqueries?

1125

How to create a table index in oracle?

1134

How to build data dictionary view an new database?

1010

What is Library Cache in Oracle?

1142

How to get a list of all user accounts in the database?

1087

What are the differences between blob and clob in oracle?

1089

How to install oracle database 10g xe?

1020

Can the query output be sorted by multiple columns in oracle?

992

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2065

What is where clause in oracle?

1031