I know this question has been asked alot of time before, but I am not able to achieve this task. I have different transaction date and times stored in the database (Type: timestamp) according to UTC timezone.
I have users from different countries visiting the website and I want to display the transaction time according to user's timezone. What is the best way to achieve it? Should I store the user's timezone in the database? or is there anyway to detect the user's timezone and convert it while echoing the date and time.
Thanks in Advance.