Allow expressions as first argument to TIMEWINDOW

[arvidj]

I would like to do:

SELECT
   FROM_TIMESTAMP(crdate) AS x,
   count(*) AS y,
   "circle" as pointstyle
   FROM fusers GROUP OVER TIMEWINDOW(FROM_TIMESTAMP(crdate), 3600*24); 

Currently the first argument must be a column reference. I store most my dates as unix timestamps, making this impractical. Could this feature be added, or are there any workarounds?

[arvidj]

I worked around this by implementing the YEAR, MONTH and DAY functions instead. I can now do:

SELECT
   FROM_TIMESTAMP(crdate) AS x,
   count(*) AS y,
   "circle" as pointstyle
   FROM fusers GROUP BY YEAR(FROM_TIMESTAMP(crdate)),  
         MONTH(FROM_TIMESTAMP(crdate)), 
         DAY(FROM_TIMESTAMP(crdate)), ; 

However, it seems like the labels on the X-axis is a bit weird. My data ranges over several years, yet I see only the time.