How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm? 

We use a) "Iconv" function - Internal Convertion.
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]") 

Showing Answers 1 - 1 of 1 Answers

sasi

  • Jun 27th, 2005
 

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

  Was this answer useful?  Yes

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]") .

  Was this answer useful?  Yes

Sucheta

  • Jun 5th, 2006
 

ToChar(%date%, %format%)

This shuld work, in format specify which format u want i.e 'yyyy-dd-mm'

  Was this answer useful?  Yes

hanug

  • May 6th, 2007
 

we can  achieve this conversion using transformer stage conversion functions in PX.

Hanu.

  Was this answer useful?  Yes

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

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")

  Was this answer useful?  Yes

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")

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions