| Subject: | better date support. |
It would be nice to have better date support. Currently date comparison isn't working for me in DTRT mode, or with an 'eq' comparison operator:
# got: '2009-01-01'
# expected: '1/1/2009'
If it makes a difference, at least PostgreSQL can grok basic date comparisons with differently formatted dates:
select 1 where cast('1/1/2005' AS DATE) = cast('2005-01-01' as date);
Perhaps one possibility is to use the database backend to check the dates, which makes sense in this context, and also saves requiring another date model to use for date checking.
For now I'll workaround this by testing with dates in the exact same format the db will produce.
Thanks for a useful module!
Mark