Mediamosa date-search has timezone problems

[Michiel.Schok]

When issuing the query

 asset?cql=((date>="09-12-2010+00:00:00")+AND+(date<="09-12-2010+23:59:59"))

I get in the respons three assets with a date-field of another day:

<date>2010-12-10 00:00:00</date>

[Michiel.Schok]

Not only with <date>, but also filter on the <videotimestamp> returns wrong asses (possibly due to timezone problems).

[robert]

asset?cql=((date>="09-12-2010+00:00:00")+AND+(date<="09-12-2010+23:59:59"))

Just a minor note that using 09-12-2010 00:00:00 is incorrect and will return wrong assets. Use datetime in format of YYYY-MM-DD HH:MM:SS. This however not the cause of the reported problem.

[Frans]

Issue will be fixed in 2.3 under the VP-Core track ticket #236

[robert]

Fixed, in MediaMosa 2.3.7 build 1301.