Bug 203680 Birt Designer "date" and "time" filter doesn't work properly
Comment from Gauri 1. the filter for date and time in designer doesnt work correctly. I tried to filter on any date column having time NOT equal to 12:00:00. On the UI, the date is shown as say Sept. 4, 1995, but internally actual date value has time 2:45 am. Now if I try to apply a filter say <expression name="expr">row["Column Binding"]</expression> <simple-property-list name="value1"> <value>"1995-09-04"</value> </simple-property-list> filter returns blank resultset. So the time value is not getting ignored. Similarly filter on another time column like given below also doesnt work. <expression name="expr">row["Column Binding1"]</expression> <simple-property-list name="value1"> <value>"14:00:00"</value> </simple-property-list> 2. Open DateAndTimeReport.rptdesign and apply filter on "date-time" column having time Not equal to 12:00:00 also doesnt work. Needs engine side investigation on this.
core/org.eclipse.birt.core/src/org/eclipse/birt/core/data/DataTypeUtil.java
import java.util.HashMap;
import java.util.Locale;
import java.util.Map;
import java.util.ResourceBundle;
import org.eclipse.birt.core.exception.BirtException;
import org.eclipse.birt.core.exception.CoreException;
import org.eclipse.birt.core.format.DateFormatter;
import org.eclipse.birt.core.i18n.ResourceConstants;
import org.eclipse.birt.core.i18n.ResourceHandle;
import org.eclipse.birt.core.script.JavascriptEvalUtil;
import com.ibm.icu.text.NumberFormat;
import com.ibm.icu.util.ULocale;
/**
 * A utility function The convert method converts the source object, which can
 * be any supported data type, into an object given specified type. If no
 * reasonable conversion can be made, throw a BirtException.
 */
public final class DataTypeUtil
{
	
	
	private static ULocale DEFAULT_LOCALE = ULocale.US;
	
	private static Map dfMap = new HashMap( );
	
	
	private static int DEFAULT_DATE_STYLE = DateFormat.FULL;
	 
	public static ResourceBundle resourceBundle = ( new ResourceHandle( ULocale.getDefault( ) ) ).getUResourceBundle( );
	public static long count = 0;