Hi, I am using a query to fetch some data based on date. date comparison is working fine in local but not in dev. sample: date is 2024-05-14 00:00:00.000 in Database table and I tried to convert date in application using trimtodays and trim todaysUTC both but date is not matching, the values are: UTC time: 2024-05-14 00:00:00.000Session time: 2024-05-14 05:30:00.000 +0530
asked
Snuhi Karmakar
1 answers
0
in your query, have you tried fetching with a date range? Like
select * from entity where dateattribute >= $beginofday and dateattribute <= $endof day?