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



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

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  


What are the informatica performance improvement tips

0 Answers   Informatica,


In a concurrent batch if a session fails, can you start again from that session

1 Answers  


Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  


Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,


which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,


what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  


What is a router transformation?

0 Answers  


Describe data concatenation?

0 Answers  


What is a poling?

2 Answers  


how to get the only updated records in the target

2 Answers  


Categories