adspace


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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key clustered index?

1026

what is collation? : Sql dba

1242

How do I remove duplicates in two columns?

1202

what is bcp? When does it used? : Sql dba

1065

what is sql server agent? : Sql dba

1188

what is schema? : Sql dba

1163

Do we need to rebuild index after truncate?

1151

what are aggregate and scalar functions? : Sql dba

1142

how to start mysql server? : Sql dba

1279

What is the current version of postgresql?

1188

how to escape special characters in sql statements? : Sql dba

1124

define sql insert statement ? : Sql dba

1108

What is the current version of sql?

1106

Does group by remove duplicates?

1120

What is the best sql course?

1062