Date type cast

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Mon Sep 18, 2006 4:20 am

Hi ,

I am very very new to DS. I am trying to find max of a date column and a time column. when i tried to find the max date using aggregator transformation. i get the below mentioned error.

Error when checking operator: When binding input interface field "XXX" to field "XXX": No default type conversion from type "time" to type "dfloat".
Error when checking operator: When binding input interface field "YYY" to field "YYY": No default type conversion from type "date" to type "dfloat".

Well, after my further analysis i could find that there is no direct type cast between Date and dfloat. so, the i could figure out 2 ways to achieve my goal.

1st: to convert the date to dayssincedate, when i try to do that i get the below error. However, to achive this conversion i am not able find the function. could any one out there help me pleaseeee???

APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseError: Parsing parameters "CCYY-MM-DD" for conversion "int32=days_since_from_date[**********](date)": APT_Conversion_DaysSince_Date: Invalid Date [CCYY-MM-DD] used for days_since_from_date type conversion.

2nd way is to convert the date field to integer and from integer to float.

to achieve both the solutions i need to figure out the function that i can use in a transformer(or any other stage) to type cast.

Thanks in advance to let me know the solution for this, Also, if there exists any other easier way to fix this issue please let me know.

Thanks again,
Waseem

kumar_s · Post by **kumar_s** » Mon Sep 18, 2006 7:47 am

Check the date format that you have entred. "CCYY-MM-DD"
Instead you can convert to julian date, which also gives you integer as output.

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Mon Sep 18, 2006 8:02 am

Kumar thanks for the reply......However, i tried with CCYY after trying out all other possibilities of date format.

Nevertheless, I would try defining the date column as julian and try. could you please let me know what is the purpose of julian date format??

kumar_s · Post by **kumar_s** » Mon Sep 18, 2006 5:39 pm

It is another similar function as what you tired. Julian data is represented in integer format. It has its own reference date. And the number of days been calculated since that reference data till the given date.
The functions available to convert to integer - JulianDayFromDate(). Do the aggregation function. Then DateFromJulianDay().

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Tue Sep 19, 2006 7:15 am

It is still not working when i try to convert to julian still it is giving error

kumar_s · Post by **kumar_s** » Tue Sep 19, 2006 6:29 pm

What error?
Basically, Aggregator handles dfloat. If you get the integer value, you should be able to find the way to use aggregator.

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Tue Sep 19, 2006 9:34 pm

i have tried different type cast like the julian date, date to days, time to seconds nothing seems to be working.

here is the sample of the data.

"19"|"45"|"a"|"b"|"c"|"d"|"e"|"f"|"2006-01-12"|"08:10:50"|
"19"|"25"|"a"|"b"|"c"|"d"|"e"|"f"|"2006-01-15"|"09:10:50"|
"12"|"25"|"a"|"b"|"c"|"d"|"e"|"f"|"2006-01-12"|"09:10:50"|
"12"|"25"|"a"|"b"|"c"|"d"|"e"|"f"|"2006-01-12"|"08:10:50"|

another question here, is it allowed to have date within double quotes??(I have tried even without double quotes)

kumar_s · Post by **kumar_s** » Tue Sep 19, 2006 10:38 pm

What are you expecting? What is not happening? what is the error you getting?
You will see the Double quotes only at the output/input file. If the quote character is given properly, you dont need to worry about it.

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Wed Sep 20, 2006 10:37 am

Wierdo Wierdo Wierdo, i posted previous 2 messages without performing the jobs properly. anyways, i am able to convert the date to julian one - THANKS FOR YOUR HELP KUMAR

rwierdsm · Post by **rwierdsm** » Wed Sep 20, 2006 1:49 pm

Actually, it's weirdo not wierdo.

Rob Wierdsma

ahmedwaseem2000 · Post by **ahmedwaseem2000** » Wed Sep 20, 2006 11:25 pm

you see i was out of my mind, then why do you expect me to spell it correctly

TonyInFrance · Post by **TonyInFrance** » Fri Mar 11, 2016 11:32 am

Old topic (I know) but I had to go through this (and other similar ones) since I was looking for a solution.

On a hunch I tried the option Preserve type = True within the Aggregator itself....worked fine...

No more warnings / aborts.

Basically what happens I guess is on choosing to preserve the datatype the output of the aggregator remains in its source format.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 11, 2016 3:10 pm

ahmedwaseem2000 wrote:you see i was out of my mind, then why do you expect me to spell it correctly

Because Rob's family name is spelled "the other way".