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

list out all the transformations which use cache?

1149


What are the different options available for update strategy?

967


How to open an older version of an object in the workspace?

1164


How we can use union transformation?

1017


How big was your fact table

1767


How to generate sequence numbers using expression transformation?

1045


How are indexes created after completing the load process?

1579


Whats the difference between informatica powercenter server, repositoryserver and repository?

1149


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2491


Write the unconnected lookup syntax and how to return more than one column.

1075


What do you mean incremental aggregation?

1036


Describe the impact of several join conditions and join order in a joiner transformation?

1029


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2041


how we can load rejected record's at run time?(not through bad files)

2336


whats the logic to load the lower level of granularity of data to fact table.

2237