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
14718 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 pl/sql package consists of?

831

What does over partition by mean in sql?

705

Write a query to find the names of users that begin with "um" in sql?

699

explain advantages of myisam over innodb? : Sql dba

796

Why select is used in sql?

687

How do I start sql from command line?

704

Why do we create views in sql?

774

What is loop in pl sql?

759

Why do we need cursors in pl sql?

716

What does varchar include?

679

What is rename in sql?

725

What is raw datatype in sql?

723

What company owns postgresql?

768

What is rownum and rowid?

759

how to concatenate two character strings? : Sql dba

739