Select date from table where date:=to_date(‘date’,’DD-MM- YYYY’);

wirte a query to filter improper date format follwing table?
date
20-apr
22-may-2010
26-jun-2010
feb-2009

i want the output

date
22-may-2010
26-jun-2010

Question Posted / sowmya

6 Answers
15757 Views
Accenture, I also Faced
E-Mail Answers

Answer Posted / sowmya

Select date from table where date:=to_date(‘date’,’DD-MM-
YYYY’);

Is This Answer Correct ?

0 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is embedded sql with example?

1018

How do you write a complex sql query?

1043

What is duration in sql profiler trace?

1063

what is the difference between primary key and unique key? : Sql dba

1015

What are sql functions? Describe the different types of sql functions?

1121

What is pivot query?

1055

what is a trigger? : Sql dba

1011

What is pl/sql table? Why is it used?

1013

what is 'mysqlshow'? : Sql dba

1007

how to include numeric values in sql statements? : Sql dba

1082

Can we commit inside a trigger?

979

What is hibernate and its relation to sql?

1100

Is pl sql a programming language?

964

What is a dynamic query?

1008

Why do we use sql constraints?

1153