Hi,

EXTRACT(MONTH FROM datecolumn) = 29

Although I have no idea what month "29" is?

> Hi i wanted to select record from tables with a fields that is a date data
> type.
> how to i select a particular month for that table.
> in MSSQL i can do a
> select * from dr_trans where month(transdate) = 29
>
> how to i do it with interbase 6.0

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."