We saved the timestamp with UTC. However, we would like to choose user to their own time zone. There is no problem at display. But problem at the date range query.
Asia/Singapore : 13/03/2017 0:00 AM (0:00)
UTC : 12/03/2017 4:00 (16:00) PM
Singapore Timezone user try to query their data betwen 13/03/2017 to 15/03/2017 , some data has been lost because of timezone.
Current query is like
SELECT * FROM transactions WHERE created_at between "2018-01-24" and "2018-01-25";