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

php mysql date datetime propel
twigmac picture twigmac · Mar 11, 2013 · Viewed 7.6k times · Source

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.

Answer

twigmac picture twigmac · Mar 12, 2013

I've figured out this solution and it works:

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

Related questions

adding 1 day to a DATETIME format value

In certain situations I want to add 1 day to the value of my DATETIME formatted variable: $start_date = date('Y-m-d H:i:s', strtotime("{$_GET['start_hours']}:{$_GET['start_minutes']} {$_GET['start_ampm']}")); What is the best way to do …

Read More
Date and time in 24 hours format

I have a date in this format Fri, 15 Jan 2016 15:14:10 +0800, and I want to display time like this 2016-01-15 15:14:10. What I tried is: $test = 'Fri, 15 Jan 2016 15:14:10 +0800'; $t = date('Y-m-d G:i:s',strtotime($test)); echo $t; But it is …

Read More
Insert date and time into Mysql

I am trying to insert date and time into mysql datetime field. When a user select a date and time, it will generate two POST variables. I have searched internet but still not sure how to do it. My code. //…

Read More