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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between writing a joiner query in ANSI style and THETA style?

1891


When do you use sql override in a lookup transformation?

560


Explain the difference between a data warehouse and a data mart?

575


What are the differences between joiner transformation and source qualifier transformation?

595


What is the format of informatica objects in a repository?

579






What is informatica?

657


How we can create indexes after completing the load process?

585


Define enterprise data warehousing?

612


Explain dynamic target flat file name generation in informatica

626


Which files are created during the session rums by informatics server?

685


What is joiner transformation?

562


What is the need for an etl tool?

611


Clarify the utilization of aggregator cache record?

554


What is complex mapping?

615


What is the scenario which compels informatica server to reject files?

579