have you ever seen something like that
RS 8.3
every run this expresion gives different result, do you have any idea, seems it's problem when using (_add_days + cast) together
_add_days ( cast('2009-01-01',DATE), 1 )
did you check in 8.2
its working fine!
8.3.
It gives a different date than expected with that combination and syntax. That's not what I expected.
But, your combination of cast and _add_days works if you remove the single quotes around the date:
_add_days ( cast(2009-01-01,DATE), 1 )
Thanks for input
In fact in my case the date was string because was taken from otherstring combinations, but it works also with _make_timestamp
something like:
_add_days(CAST(_make_timestamp(2009,09,16),DATE),1)
where 2009,09,16 I take from string
Thanks