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.