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?

It’s not mysterius at all. 2018-22-06=1990… :slight_smile:

You need to put the value in quotes.

Thanks, that was it! :slight_smile: