LLBLGEN 3.0 .net Framework 2.0 Oracle 9i/10g

Dear Support team,

I am trying filter date with following code.

var filterEventdate = new FieldCompareValuePredicate(EventFields.Eventdate, null, ComparisonOperator.Equal, eventdate);

But I want to ignore time and check if record exists with date.

Ex: I have a record 23/10/2010 11:45:13 AM, if i execute the above filter on 23/10/2010 11:45:15 no record is fetched because of time. So I want filter only by date ignoring time. How do i do this ?

First ask to yourself, how would you write it in sql, then you could use a DBFunctionCall.

Related info: http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_functions_2127.htm Calling a DB Function

daelmo wrote:

First ask to yourself, how would you write it in sql, then you could use a DBFunctionCall.

Related info: http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_functions_2127.htm Calling a DB Function

Thanks got it