I am using created date of ubercart order to compare with filter selected values of date.
created date is in timestamp with time. Where as filter selected values it is just date and if try to convert the date to timestamp, its not fetching accurate results as per filtered dates.
I have attached the image for clear understanding.
I have used this as query:
$query = $query->condition('uc.created',array($from_timestamp,$to_timestamp),'BETWEEN');
Any suggestions ? Thanks in advance.