INTERVAL date arithmetic

[Robin Moffatt]

Hi,
I have a date in a table, that I want to calculate how many days it is
between then and current date.
I have read the docs on date time formats, including intervals (
http://drill.apache.org/docs/date-time-and-timestamp/), as well as date
time functions (
http://drill.apache.org/docs/date-time-functions-and-arithmetic/).

I have a query that returns the interval:

0: jdbc:drill:zk=local> select p.post.published_at,age(p.post.published_at)
FROM   dfs.data.ghost_posts_rm p limit 5;
+---------------------------+-----------+
|          EXPR$0           |  EXPR$1   |
+---------------------------+-----------+
| 2003-06-28T23:00:00.000Z  | P162M24D  |

but I can't see how to transform the INTERVALDAY into an int of days alone.

Any suggestions?

thanks.