Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How to call shell scripts from informatica?

1001


What is lookup transformation?

1048


What are the issues you have faced in your project? How did you overcome those issues?

2373


How to configure mapping in informatica?

1179


What is a mapplet/worklet in informatica?

1194


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2312


Why is sorter an active transformation?

1136


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1973


Is stop and abort are same in informatica?

1010


How to do unit testing in informatica?

1181


What is mapplet in informatica?

1067


What is difference between a gateway node and worker node?

1147


What is the difference between STOP and ABORT options in Workflow Monitor?

1264


How to generate or load values in to the target table based on a column value using informatica etl tool.

1084


What is lookup change?

1057