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

Define commit?

0 Answers  

What is trigger and types?

0 Answers  

How many types of cursors are available in pl/sql?

0 Answers  

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

Where is all the data on the internet stored?

0 Answers  




What is difference between select statement and cursor

3 Answers   JDA,

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  

What are the methods of filing?

0 Answers  

What are commit, rollback, and savepoint?

0 Answers  

What is a ddl command?

0 Answers  

How to display the current date in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories