Time zone Issue default time UTC 00:00 ? How to change timezone Help Please ASAP

# Time zone Issue default time UTC 00:00 ? How to change timezone Help Please ASAP

If what you meant is the timezone in your date column, you could use this (if you use PostgreSQL):

SELECT date_column_name AT TIMEZONE ‘TIMEZONE_CODE’ FROM table

Find your TIMEZONE_CODE here

For example, I am living in GMT+7, and I want to SELECT date_order:

SELECT date_order AT TIMEZONE ‘WAST’ FROM order

As far as I know, Redash does not support to automatically convert the timezone on your database. Therefore, you need to define it every time you use the date (even in WHERE clause)

Exactly right @rafialvin. For anyone lurking: this is a feature currently on our radar. We will announce it in a blog post as soon as its available to users.