Fliter on date field

[Guillaume KUHMEL]

Hi all,

I encouter a problem on dealing with filters on a date field.
On my developpement environnement, my filter works fine.
On my customer integration environnement, the same filter does not work.

The filter is coded like this :


            long today = calendar.getTime().getTime();                          
         
            ContainerFilterBean archiveFilter = new 
ContainerFilterBean(CompositeActualite.Actualite.FIELD_NAME_FIN_PUBLICATION, 
true, jParams.getEntryLoadRequest());      
            archiveFilter.addClause(ContainerFilterBean.COMP_BIGGER_OR_EQUAL, 
String.valueOf(today));               
            filters.add(archiveFilter);


I want to get all news (ie. Actualite) where the publication end date is not 
over.

Have you any idea for the reason of this difference between the integration and 
the developpement ? THe database of integration is Oracle and for dev i use 
HSQL : can it be the source of the problem???

Thanks a lot !

Guillaume KUHMEL - Consultant