ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories >> Software >> Data-Warehouse >> Informatica
 
 
 
Question
How to write a procedure for a date which is in three
different formats,and you want to load into datawarehouse in
any single date formate
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
Answer
Use to_date function in an expression. This will allow you 
to change any date's format into other one.
Ex: 
to_date('070903', 'yyyy/mm/dd') would return a date value 
of 2003/07/09. 
to_date('20020315', 'yyyy/mm/dd') would return a date value 
of 2003/07/09.
 
0
Vaibhav Bhandeo
 
View All Answers
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com