Subject Re: [IBO] SQL Question
Author Helen Borrie
At 07:58 AM 30-05-01 -0700, you wrote:
>Hi all
>I was looking suggestion on how to select all the records in a table from
>today back 30 days
>is there some date variable I can use in IB6 to accomplish this?
>select * from tablename
>where datefield > (today - 30)
>how can I accomplish this ??

Almost exactly like your pseudocode:

where datefield > 'TODAY' - 30


where datefield > CURRENT_TIMESTAMP - 30
(if you want to get down to exact time of day).


All for Open and Open for All
InterBase Developer Initiative ยท