Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi , Is there a way to have date column as input and number if days stored in Integer format.
i want to subtract them and have my output stored in a date column. The inc() function will not work because i have the column name and can be used only for incrementing dates by a number.
Suppose i want to decrement a date by a particular column having bigint , then could you pls guide how to do achieve that ?
Hi,
If all your column's values are positive and you want to decrement from it, you can just multiply it by -1 to achieve the desired output:
inc(date, -1*delta_days, "days")
Best,
Harizo
Hi,
You can pass negative values to the inc() function if you need to decrement dates, like this:
Hope this helps!
Best,
Harizo
Thanks @HarizoR for the response. I am having fixed positive integers, is it possible to decrement dates by positive integers. or do you have any ways to transform a postive number to negative number=?
Hi,
If all your column's values are positive and you want to decrement from it, you can just multiply it by -1 to achieve the desired output:
inc(date, -1*delta_days, "days")
Best,
Harizo
Thanks a lot @har
. it worked.