write asql query to filter improper date format?
date
20-apr
11-mar-2010
30-may-2010
feb-2009
i want the output
date
11-mar-2010
30-may-2010
- 2 Answers
- 5847 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasad
The function appears like this IIF(IS_DATE(DATE, 'DD-MON-YY'),TRUE,FALSE)
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / gyana
u can use the TODATE() function to make it as default date
and time
| Is This Answer Correct ? | 2 Yes | 0 No |
how many session run unix environment what command using ?
What do you mean by enterprise data warehousing?
How to generate a single mapping for both the historical and incremental load.
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
Did u used latest transformations of 8.6.0? for what?
What are the restrictions of union transformation?
Why we select the table which has minimum number of records as Master table in joiner?
how we do performence tuning in informatica
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
Teradata 
