> Hello there, in a MySQL database i could use:
> mysql> SELECT something FROM tbl_name WHERE TO_DAYS(NOW()) -
> TO_DAYS(date_col) <= 30;
>
> I couldn't find a way to do the same with Firebird, do i need to make a
> UDF or something like this? I'm new using it so i'm having troubles,
> hope you can help me.
>
> Thanks
>
> --
> Rosivaldo Azevedo Ramalho

Just try to subtract the dates e.g. CURRENT_DATESTAMP-DATE_COL

Alan