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

How to generate sequence numbers using expression transformation?

0 Answers   Informatica,


Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,


what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,


How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,


How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,






I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,


how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,


what is the -ve test case in your project.

0 Answers   CTS, TCS,


What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,


how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,


How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,


Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,


Categories