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
6202 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

Is there any way to read the ms excel datas directly into informatica?

0 Answers

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers Amazon, IBM, Wipro,

What is A cache?

2 Answers

How to load the data from people soft hrm to people soft erm using informatica?

0 Answers

How do you implement unconn. Stored proc. In a mapping?

1 Answers

what is bitmap index? did u use it?and how to use it in informatica

1 Answers IBM,

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers

What do you mean by worklet?

0 Answers

What do you mean by filter transformation?

0 Answers

what is distinct

4 Answers

how many session run unix environment what command using ?

1 Answers HCL,

What is a code page?

0 Answers

For more Informatica Interview Questions Click Here