Winfried,

        You can qualify the date search using the DATE(timestamp) function.
For example,

                Select ........ where date(date_time)='mm/dd/ccyy'

for the date portion of the timestamp value in the activity log table
(actlog).  You could parameterize the search value using the ('$1')
replacement form (instead of specifying the actual date) to create a
re-usable script.

        Gary L. Ison
        Governor's Office for Technology
        101 Cold Harbor Drive
        Frankfort, Ky.   40601
        Phone:  (502) 564-8724
            Fax:  (502) 564-6856
E-mail: Gary.Ison AT mail.state.ky DOT us <mailto:Gary.Ison AT mail.state.ky 
DOT us>