Hey,
I have been scratching my head about this for a couple of hours now, and would appreciate if someone had an idea what’s happening here. I built a query with redash with a date parameter which I wanted to use to filter some event data by timestamp. Instead of returning the selected date, redash returns a mysterious integer value when I try to use the value in a where clause or just display it
select date{{start}};
This seems to be the case even on the demo instance of redash, so I assume this is on purpose.
http://demo.redash.io/queries/7125/source?p_start=2018-06-22
How do I convert this mysterious integer into a normal SQL timestamp?