Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / dinesh

Answers were Sorted based on User's Feedback



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

Answer / praveen

select to_date('Column_Name','dd-mon-yyyy') from table_name;

Is This Answer Correct ?    23 Yes 15 No

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

Answer / pulakesh

select * from testdate
where to_date(column1,'dd-mon-yyyy')=to_date(column1,'dd-
mon-yyyy') and length(column1)>8

Is This Answer Correct ?    8 Yes 5 No

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

Answer / dipti

select * from TABLE1
where VSIZE(column_name) > (select VSIZE('DD-MON-YYYY') from dual)

Is This Answer Correct ?    0 Yes 0 No

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

Answer / kumar

select * from employees
where
length(hire_date)=length(sysdate)

Is This Answer Correct ?    2 Yes 6 No

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

Answer / john bershan

select to_char(column_name,'dd-mon-yyyy') from <table_name>;

Is This Answer Correct ?    1 Yes 6 No

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

Answer / sowmya

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

Is This Answer Correct ?    0 Yes 8 No

Post New Answer

More SQL PLSQL Interview Questions

What is rollback?

0 Answers  

Is sql considered coding?

0 Answers  

Explain what is a database?

0 Answers  

What is the difference between inner join and left join?

0 Answers  

Can you have a foreign key without a primary key?

0 Answers  




How to find the count of letter "L" in HELLO

7 Answers   HP,

How do you modify a column in sql?

0 Answers  

What are different types of tables in sql?

0 Answers  

What Is a Trigger? How Do You Use It?

3 Answers  

Why is pl sql needed?

0 Answers  

what is bulk bind

4 Answers   TCS,

what are the different types of joins?

4 Answers   Choice Solutions,

For more SQL PLSQL Interview Questions Click Here
Categories