Subtract a column from another column with a different datatype

UDA

Subtract a column from another column with a different datatype

Hi

I have two columns Close time(Integer) and pickup Completed Time (Date) .How do I subtract Close time from Pickup Completed where both columns have different data types

Can anybody give me the exact syntax

Any help would be appreciated

Thanks

Shashank
1 REPLY
Junior Supporter

Re: Subtract a column from another column with a different datatype

In fact, DATE is INTEGER: (YEAR - 1900) * 10000 + MONTH * 100 + DAY

Cheers.

Carlos.