Time showing different in heay.ai db

Follow

zacharia mathew

• September 28, 2022 05:18

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

0

• 

  Candido Dessanti

  • September 28, 2022 08:20

  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.

  Regards, Candido

  0

  Comment actions Permalink

Please sign in to leave a comment.