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
This seems to be the case even on the demo instance of redash, so I assume this is on purpose.
How do I convert this mysterious integer into a normal SQL timestamp?