aslam Sep 18th, 2005 Here is the right conversion:Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-YDM[4,2,2]") .
Sucheta Jun 5th, 2006 ToChar(%date%, %format%)This shuld work, in format specify which format u want i.e 'yyyy-dd-mm'
hanug Profile Answers by hanug May 6th, 2007 we can achieve this conversion using transformer stage conversion functions in PX.Hanu.
ganpu Profile Answers by ganpu Dec 16th, 2009 I will explain how to Convert a mm/dd/yyyy format to yyyy-dd-mm Below is the format Oconv(Iconv(Filedname D/MDY[2 2 4] ) D-YDM[4 2 2] ) here first Iconv(Filedname D/MDY[2 2 4] ) will convert our given date in the internal formatlater Oconv( Inter_date_format D-YDM[4 2 2] ) will convert our internal date format to required yyyy-dd-mm...Regards,KK
manju_thanneeru Profile Answers by manju_thanneeru Questions by manju_thanneeru Jul 6th, 2010 These iconv, oconv functions exists in server jobs. In px we convert using juliandayfromdate(). If it is wrong correct me.
kiran54 Profile Answers by kiran54 Dec 19th, 2010 Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-YDM[4,2,2]")
venkataram.chv Profile Answers by venkataram.chv Mar 30th, 2013 DateToString(date,"%yyyy:%mm:%dd")Using datetostring function in transformer stage example DateToString(inputcolumnname(ex Dob),"%yyyy/%mm/%dd")
muralidhar May 30th, 2013 by default datastage date format is :yyyy-mm-dd.The input is mm/dd/yyyy. Date To String(inputdate,"%mm%dd%yyyy")
Muralidhar Jul 29th, 2013 by default datastage date format is :yyyy-mm-dd.The input is mm/dd/yyyy. String_to_date(inputdate,"%mm%dd%yyyy")
vipul choudhary Aug 22nd, 2013 There are two types of hash file1. modulus hash file- file size increases randomly 2. splitting hash file-file size decreases randomly
How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?
b) "Oconv" function - External Convertion.
Function to convert mm/dd/yyyy format to yyyy-dd-mm is
Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]")
Answer Question
Click here to Login / Register your free account
Related Answered Questions
Related Open Questions