Timestamp with UTC Issues

Discussion
1

Hello Team Retool,
I have a doubt, I usually upload transaction data in retool database and to view it in i add UTC +05:30 and use that timestamp column in writing custom queries by joining other tables from retool database.

While joining two different tables from retool database, what does it consider,

does it consider UTC +05:30 or without it.
please give me a clarity regarding this

2

You should use moment for the time you want to add +5:30
https://momentjs.com/docs/#/manipulating/utc/