DSXchange

HI all,

Can you guys let me know the easiest way to implement Date conversion below

scenario

1/7/02 0:00:00 to db2 date 2002-01-07

Thanks!

Hi All,
Question: I have a transformation to subtract no. of months from MonthEndDate
(MonthEndDate(Date field) - Months(Integer Field))

Example: 01/31/2003 - 1 should give 12/31/2002

Do we have any special date function to handle or is there a way to handle this?

did you connect to DB2?

if so use
db2 "load from /dev/null of del replace into schama.tablename nonrecoverable"

Yes Kenneth
I have couple of datasets to couple of transformers and funneling them.

Hey Guys,
Can you help me whats the warning message comming for?

Here is the message

Fn_CLlkp: When checking operator: Dropping "DTE_INT_BEGIN" in transfer from "inRec" to "outRec".

Thanks
cmg

Ray,
Can you give me a detail example.
like how do i convert 105030 to 2005/01/30
I tried to use the function in transformer date from juliandate but iam getting output as **********.
Any help is appreciated

Thanks in advance!
cmg

Thanks Ray n Bala.
I have a function in PX like DatefromJulianDay whether it works.
Hope this will not work
Any suggestion?

Hi Folks, I have a date conversion from julian to DB2 format YYYYMMDDi.e CYYnnn(105032) Where C = 0 If Century is 1900 else 1 is Century 2000 YY - Two Digit Year nnn - The Current Day of the year in 3 digits eg: Jan 1 is 001, Feb 1 is 032 Can you guys assist the logic to implement. Thanks in advance...