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
* Double -> java.lang.Double<br>
	 * Character -> java.lang.String<br>
	 * Decimal -> java.math.BigDecimal<br>
	 * Date -> java.sql.Date<br>
	 * Time -> java.sql.Time<br>
	 * Timestamp -> java.sql.Timestamp<br>
	 * Blob -> java.sql.Blob<br>
	 * Clob -> java.sql.Clob<br>
     * Boolean -> java.lang.Boolean<br></i>
	 * @param odaDataTypeCode   an ODA data type code
	 * @return  the ODI type class that corresponds with 
	 *          the specified ODA data type
	 * @throws BirtException if the specified ODA data type is not a supported type
	 */
	public static Class toOdiTypeClass( int odaDataTypeCode )
			throws BirtException
	{
		if ( odaDataTypeCode != Types.CHAR
				&& odaDataTypeCode != Types.INTEGER
				&& odaDataTypeCode != Types.DOUBLE
				&& odaDataTypeCode != Types.DECIMAL
				&& odaDataTypeCode != Types.DATE
				&& odaDataTypeCode != Types.TIME
				&& odaDataTypeCode != Types.TIMESTAMP
				&& odaDataTypeCode != Types.BLOB
				&& odaDataTypeCode != Types.CLOB
                && odaDataTypeCode != Types.BOOLEAN
				&& odaDataTypeCode != Types.NULL )
		{
			throw new CoreException( ResourceConstants.INVALID_TYPE);