O$: Today in Frontbase

Mike Matthews omnis at lineal.co.uk
Fri Apr 24 17:58:40 EDT 2009


Thanks Geert,

I'll start with this lot now.

Mike Matthews



On 24 Apr 2009, at 17:53, Geert Landuyt wrote:

> 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
>>
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com





More information about the omnisdev-en mailing list