Comment 3 for bug 719032

Here is a good trick:

Use the above select statement to call another widget:

(#(inherit:311|SELECT FLOOR(TIMESTAMPDIFF(Day,'((created_at))',NOW())) AS DiffDate)#)

And in that widget put the content as:

((DiffDate)) <php if ((DiffDate)) = 1 then day else days php> ago