1

I’ve got a database, which stores UTC timestamps, from which I need to create reports for user-selected time ranges. Naturally, the users are not thrilled about having to convert times to UTC in their head.

Is there a way to insert user’s timezone into SQL query? (Can’t hardcode it, because not all users are in the same timezone).

2

Welcome to the forum! Please search the forum before posting new questions. We answered this exact question not long ago.

No.

Dates and times are passed to the database as-is. If the database stores them as UTC then your users need to enter them in UTC.

1 Like
3

We answered this exact question not long ago.

I wouldn’t say “exact”. I am not expecting Redash to perform time conversion, just to tell me what the user’s time zone is.

So it sounds like what I need just isn’t possible with Redash?

4

Fair point.

Yes.

Like I mentioned in the linked post, it’s on our roadmap to add timezone offset by user which would make your use-case possible.