Re: from_days()

[Jim Faucette]

PinkeshP@stripped wrote:
> 
> following query returns NULL
> any idea why?
> 
> from_days(to_days(CURDATE()+20));
> 
> it works fine on windows version of MySQL. But returns NULL on UNIX
> 

It looks like on UNIX it sees 7-26-99 + 20 days as an improper date for
to_days. But this works:
  from_days(to_days(CURDATE())+20);

  jim...