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...

convert yyyy mm dd to dd mm yyyy?

Answer Posted / jerry

to_date(to_char(Field_Name,'dd-mm-yyyy'),'dd/mm/yyyy');

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State the difference between an operational datastage and a data warehouse?

1053


What could be a data source system?

939


What are the components of ascential data stage?

1110


What is "fatal error/rdbms code 3996" error?

1187


What are the functionalities of link partitioner and link collector?

947


CHANGE CAPTURE

1256


What all the types of jobs you developed?

1113


What are the different kinds of views available in a datastage director?

969


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2834


whom do you report?

1879


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3261


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3410


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2226


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2196


Define Job control?

1059