I would love something that handles dates to the solr/lucene format

[stefanooldeman]

This is the DateField that is handled in solr. But this is slightly different than the full RFC 3339. So this is how i convert my dates. see:

RFC 3339 :
2011-12-01T00:00:00+01:00
solr expects:
2000-05-23T22:00:00Z

// return everything but the 6 chars and add a Z (The trailing "Z" designates UTC time and is mandatory)
$date = new Zend_Date($input);
$dateValue = $date->toString(Zend_Date::RFC_3339);
$dateValue = substr($dateValue, 0, strlen($dateValue) -6) . 'Z';

I have a few questions:

1. where should this be added eg. within a helper or intergrated in the Solarium_Query_Select etc.
2. is this wanted functionality / how do other think about this feature

[basdenooijer]

I think a date helper can be useful, this way users don't need to know to exact details of the format required by Solr.

Since dates can be used for all query types, so I think this should be placed in the Solarium_Query_Helper class. This is already available in all queries using the getHelper method.

Solarium should not depend on Zend Framework for the date conversion. Luckily the date conversion is not hard to implement. I've seen an example of this in a commit of Gasol, see:
https://github.com/Gasol/solarium/blob/a720c96cf39e0c01074fa89fce39ddbdb3d4cf8d/library/Solarium/Document/Helper.php
He has done several contributions to Solarium, but this code wasn't included.

The ISO8601 format is the right one. The DateTime class is part of the PHP core since 5.2 and Solarium requires PHP 5.2+ so this can safely be used. The method in the example would need to be moved to the query helper class.

[basdenooijer]

I'm closing this issue, as the discussion is now ongoing in issue #62