At 11:03 AM 8/06/2004 +0800, you wrote:

> Hi,
> 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.

Select EmpName, EmpID from EMP where logoutdate >= CURRENT_DATE AND
logoutdate < (CURRENT_TIMESTAMP + 1)

/heLen