Time showing different in heay.ai db
HI, 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(); EXPR$0 2022-09-28 05:16:38
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.
Please sign in to leave a comment.