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
- 6 Answers
- 13604 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / praveen
select to_date('Column_Name','dd-mon-yyyy') from table_name;
| Is This Answer Correct ? | 23 Yes | 15 No |
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 |
Answer / dipti
select * from TABLE1
where VSIZE(column_name) > (select VSIZE('DD-MON-YYYY') from dual)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kumar
select * from employees
where
length(hire_date)=length(sysdate)
| Is This Answer Correct ? | 2 Yes | 6 No |
Answer / john bershan
select to_char(column_name,'dd-mon-yyyy') from <table_name>;
| Is This Answer Correct ? | 1 Yes | 6 No |
Answer / sowmya
Select date from table where date:=to_date(‘date’,’DD-MM-
YYYY’);
| Is This Answer Correct ? | 0 Yes | 8 No |
What are pl sql procedures?
what is difference between procedure and function, procedure and trigger?
How do sql triggers work?
define sql insert statement ? : Sql dba
What are the usages of sql?
What does dml mean?
State the advatage and disadvantage of Cursor's?
What is sql and db2?
How can I tell if sql is running?
What is the current version of postgresql?
List the differences between plsql - function & procedures
How many parts of a pl sql block are optional?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
