sasi

• Jun 27th, 2005

 

fine 
but what is the difference between diff.types of hash files

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 format

later  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 file

1. modulus hash file- file size increases randomly
2. splitting hash file-file size decreases randomly