I have trouble calculating the difference in days between two date columns. No matter how I cast the two columns, it keeps returning the error posed below. On the link below the datediff function is given as an example, so I assume it is possible to use it in the query editor.
Hope somebody can help me out!
ERROR: function pg_catalog.date_diff("unknown", timestamp with time zone, timestamp with time zone) does not exist Hint: No function matches the given name and argument types. You may need to add explicit type casts.