Magento

I use
->addAttributeToSelect(’news_from_date’)
->addAttributeToSelect(’news_to_date’)
succesfully to get those date values in the adminhtml product grid.
But their time is always 00:00:00.
Is it possible to strip the time from the result in the product collection?
Like one would do in a SQL query: DATE(timestamp_field)…

Nice, solved myself! It is where the columns are added. I added the “type” parameter:

$this->addColumn(’news_from_date’,
array(
‘header’ => Mage::helper(’catalog’)->__(’News from’),
‘width’ => ‘40px’,
‘index’ => ‘news_from_date’,
‘type’ => ‘date’,
));

$this->addColumn(’news_to_date’,
array(
‘header’=> Mage::helper(’catalog’)->__(’News to’),
‘width’ => ‘40px’,
‘index’ => ‘news_to_date’,
‘type’ => ‘date’,
));