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
return DataType.STRING_TYPE;
		else if ( BigDecimal.class.isAssignableFrom( clazz ) )
			return DataType.DECIMAL_TYPE;
		else if ( clazz == java.sql.Date.class )
			return DataType.SQL_DATE_TYPE;
		else if ( clazz == java.sql.Time.class )
			return DataType.SQL_TIME_TYPE;
		else if ( Date.class.isAssignableFrom( clazz ) )
			return DataType.DATE_TYPE;
		else if ( byte[].class.isAssignableFrom( clazz ) )
			return DataType.BINARY_TYPE;
		else if ( Clob.class.isAssignableFrom( clazz )
				|| clazz.getName( )
						.equals( "org.eclipse.datatools.connectivity.oda.IClob" ) )
			return DataType.STRING_TYPE;
		else if ( Blob.class.isAssignableFrom( clazz )
				|| clazz.getName( )
						.equals( "org.eclipse.datatools.connectivity.oda.IBlob" ) )
			return DataType.BINARY_TYPE;
		else if ( clazz == Boolean.class )
			return DataType.BOOLEAN_TYPE;
		
		return DataType.UNKNOWN_TYPE;
	}
	/**
	 * Converts an ODA data type code to its 
	 * corresponding Data Engine API data type constant
	 * defined in DataType.
	 * @param odaDataTypeCode   an ODA data type code
	 * @throws BirtException if the specified ODA data type code