I want to query last 24 hrs of Date field in my custom object. But when I debug the value, they become like that.
Example : Date.today() : 2013-10-04 00:00:00 last24hrs : 2013-10-03 00:00:00
So totally,no current time of query made is used. Now it is like I am querying for since yesterday results.
My requirement is using hour,min,second too. But the custom field is only Date. Example if I make query at 2013/10/04 13:00 , then the result of since 2013/10/03 13:00 should appear. before 13:00 hr results should not come out.
How should I approach this issue?