Time showing different in heay.ai db

linux time and heavy.ai db time showing 5 hour 30 minute difference, how to make heavy db time same as linux time.

[wicp@aaalab-5 heavyai]$ date
Wed Sep 28 10:46:30 IST 2022

heavysql> select now();
2022-09-28 05:16:38

Hi @zachariam,

Since we store timestamps in UTC format the data returned by the server is returned as that, so it’s returning the UTC time and it’s ignoring the timezone setting of the server.
Also, all the dates stored in the database are untouched and stored as they are UTC.

Do you need to have the timestamp returned in the server TZ just using the now() function? Maybe we could add a setting on the season or the server.