O$: Today in Frontbase

[Geert Landuyt]

values (current_date) : shows current date
values (current_timestamp) : shows current date and time

to find all records for today where the database column is of type  
TIMESTAMP
you could do following :
Calc ivDateTimeFrom as today with time 00:00:00
Calc ivDateTimeTo as today with time 23:59:59
WHERE DIARY_DATE BETWEEN @[ivDateTimeFrom] AND @[ivDateTimeTo]

to find all records for today where the database column is of type DATE
you could do following :
WHERE DIARY_DATE = CURRENT_DATE

Regards,
--
Geert Landuyt



On 24-apr-09, at 17:12, Mike Matthews wrote:

> Hello FB users,
>
> After reading the docs a bit, I have tried to find the reserved  
> word that means TODAY.  I have tried CURDATE but no joy.  I want to  
> find all records with a DateTime field whose date part is TODAY.   
> It may be a mismatch with it being DateTime though.
>
> 'WHERE tablename.DIARY_DATE = [#D]' doesn't work in my fetchall.
>
> Any answers please?
>
> Thanks
>
> Mike Matthews
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
>