id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc
661,Query language: handle 'null' dates more elegantly,karel@…,,"[jira2trac import : issue created on June 26, 2008 11:18:12 AM CEST [http://issues.cocoondev.org/browse/DSY-661] ]


Currently the repository throws nullpointer exceptions on this query if the date $FooDate is null:

select Year($FooDate) ...

Solution one: Year(null) returns null (same for other date functions) [[br]] Solution two: Year(null) returns 0 (same for other date functions)

pro solution one: makes sense [[br]] pro solution two: makes sense (but less), allows for nifty date calculations: Year($FooDate) + DayOfYear($fooDate)

Also, a Milliseconds(date) function would be nice.
",Improvement,closed,Minor,,,2.2,,,