My rails 6.0.3 application works on a postgres database and it has an order_datetime column(timestamp without time zone) and Configured time_zone to Kolkata in application.rb. It is +5.30 hours ahead of UTC
config.time_zone = ‘Kolkatta’
When user submit the parameter of order_datetime(2024-08-12 01:42:02 AM), the value will be stored as previous date in the database column like 2024-08-11 20:12:02. But will show the actual value 2024-08-12 01:42 AM when retrieving by app(l object.order_datetime).
No problem so far.
Problems start with searching by date. When user searches by date 2024-08-12, no result is generated on this date because the value in database is stored in an earlier date.
Please anyone helps me to fix this issue.