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

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1064

Cite the differences between execution of triggers and stored procedures?

1078

what is a join? : Sql dba

1037

what does the t-sql command ident_current does? : Transact sql

982

How do you update sql?

981

What is primary key and unique key?

1121

What is a memo field?

969

What is compilation error in pl sql?

979

Do foreign keys improve performance?

1026

What are sql data types?

1030

How can you create an empty table from an existing table?

1081

What is meant by truncate in sql?

1068

Why stored procedures are faster than query?

1028

What does := mean in pl sql?

1046

What is the difference between Union and Union all. Which is faster.

1403