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
What is the difference between writing a joiner query in ANSI style and THETA style?
When do you use sql override in a lookup transformation?
Explain the difference between a data warehouse and a data mart?
What are the differences between joiner transformation and source qualifier transformation?
What is the format of informatica objects in a repository?
What is informatica?
How we can create indexes after completing the load process?
Define enterprise data warehousing?
Explain dynamic target flat file name generation in informatica
Which files are created during the session rums by informatics server?
What is joiner transformation?
What is the need for an etl tool?
Clarify the utilization of aggregator cache record?
What is complex mapping?
What is the scenario which compels informatica server to reject files?