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
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
What is record variable?
What is a pdo connection?
What is cte sql?
What are sql injection vulnerabilities?
what is a unique key ? : Sql dba
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is indexing oracle sql?
Why partition by is used in sql?
explain the difference between delete , truncate and drop commands? : Sql dba
Who is the owner of mysql database?
Does group by remove duplicates?
is mysql query is case sensitive? : Sql dba
Why do we need view in sql?
Which join is like an inner join?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?