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

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

Question Posted / nazim

5 Answers
7933 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 to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2504

What is oracle used for?

968

What is merge statement used for?

968

What is a select query statement in oracle?

899

State some uses of redo log files?

943

How to view existing locks on the database?

994

what's query optimization and without use of IN AND Exist can we get another way data from query

2086

What are the major difference between truncate and delete?

979

What is oracle and what are its different editions?

1007

definition of cluster and non-clustered index?

2959

Describe varray?

1005

Does oracle partitioning improve performance?

943

What is an oracle database?

989

What are the data types in oracle?

976

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1617