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
16099 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

How do I count records in sql?

1054

What is difference between inner join and self join?

1138

What are the disadvantages of not performing database normalization?

1217

Explain what is rdbms?

1091

Why select is used in sql?

1070

what is isam? : Sql dba

1067

What is transaction control language (tcl)?

1187

What are % type and % rowtype?

1083

Can we use pl sql in mysql?

1063

What are local and global variables and their differences?

1143

Which command is used to call a stored procedure?

1055

What is the most restrictive isolation level? : Transact sql

1128

Explain polymorphism in pl/sql.

1171

how to drop an existing view in mysql? : Sql dba

1107

What is where clause in sql?

1088