Fliter on date field

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