paul wrote:

> Thanks, my logout field is Timestamp.
> I want to compare only date value in the
> Timestamp field. How to do it.
> Say, I got Timestamp field with 07/06/2004 15:54:00
> I got date 07/06/2004 00:00:00
> How to do the date comparion between timestamp and date.

WHERE CAST( LOGOUT AS DATE ) = XDATE

You may need to 'CAST' the XDATE as a date, I feed a parameter which is
just the '07/06/2004'.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services