Can we write to_date(three arguments) ? Will it work ? Advance thanks

Can we write to_date(three arguments) ? Will it work ?
Advance thanks

Question Posted / cmanojkumar

1 Answers
6339 Views
Puma, I also Faced
E-Mail Answers

Can we write to_date(three arguments) ? Will it work ? Advance thanks ..

Answer / pandu

ALTER SESSION SET NLS_TERRITORY = 'INDIA';

SELECT TO_DATE(
'January 15, 1989, 11:00 A.M.',
'Month dd, YYYY, HH:MI A.M.',
'NLS_DATE_LANGUAGE = INDIA')
FROM DUAL;

Is This Answer Correct ?

3 Yes

1 No

Post New Answer

More Informatica Interview Questions

daily how much amount of data send to production?

4 Answers HSBC,

What is sql query override? When did u use sql query override?

1 Answers TCS,

What is a filter transformation?

0 Answers

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers Patni,

How many input parameters can exist in an unconnected lookup?

0 Answers

What is parameter file?

2 Answers

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers IBM,

What are the data movement modes in informatica?

0 Answers Informatica,

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers

Can i create a lookup table without cache.

7 Answers iGate,

What are the differences between oltp and olap?

0 Answers

For more Informatica Interview Questions Click Here