Re:how to select a date column from a table where the month is equal to this
month.

I like to select record from mytable where the field Tdate is this month.

i know that to select the record with date that is today used
select * from mytable where Tdate = 'today'
how to select it for this month.


i'm using ib6.0

Tommy