How can I filter date-time columns by dates in Propel 1.6?

Question

I would like to filter results as in ``` $searchDate = "2013-03-01"; $query->usePublicationQuery() ->filterByPublishedAt($searchDate) ->endUse(); ``` However, the problem is, that the values in this column contain also the time, i.e. they're actually timestamps (e.g. "2013-03-01 08:27:12") and I'm not allowed to change that in the schema. So how can I possibly match the pure date ignoring the time? The above query only matches entries with the time 2013-03-01 00:00:00. But I want all entries with 2013-03-01 as date, regardless of the time.

Accepted Answer

I've figured out this solution and it works:

```
->filterByPublishedAt(array("min" => $searchDate." 00:00:00", "max" => $searchDate." 23:59:59"))
```

How can I filter date-time columns by dates in Propel 1.6?

Solution

Problem