I have a view in PostGIS that has a bunch of points and I want to symbolize in QGIS (3.2.2) by the age of the points. I am trying to use this expression (or something like it):
day(age(ts, now()))
But that doesn't appear to do anything (returns null). The column is a timestamp (UTC). Is there anything I need to do the ts timestamp value before passing into the age(,) function.
I know I could force it from the PostgreSql by adding a derived column in the view, but I feel like I wouldn't need to do that.