u can use the TODATE() function to make it as default date and time

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

Question Posted / gyana

Answer Posted / gyana

u can use the TODATE() function to make it as default date
and time

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Enlist some properties of sessions.

1065

What are the tasks that source qualifier perform?

1097

How can we remove the duplicates from flat file source?

1034

Explain the types of lookup transformation?

1043

Describe the impact of several join conditions and join order in a joiner transformation?

1059

What are the restrictions of union transformation?

1039

wf dont have integration severances how you can run?

1938

tell me 5 session failure in real time how can you solve that in your project?

2294

How to improve the performance of a session using sorter transformation?

1144

How do you set a varible in incremental aggregation

1887

can u any challenge your project?

2029

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2514

What is target load order?

1241

Partition, what happens if the specified key range is shorter and longer

2492

What are the types of caches in lookup? Explain them.

969