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
- 13582 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 is bind reference and how can it be created?
what is an associative array with example?
What is the difference between microsoft access and sql server?
how to add a new column to an existing table in mysql? : Sql dba
What is nvarchar max in sql?
What is sql indexing?
What are the advantages of sql?
how to retrive only second row from table?
what is a composite primary key ? : Sql dba
what is 'mysqlshow'? : Sql dba
Explain the purpose of %type and %rowtype data types?
what is ref cursor in pl/sql?
-
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)
