thanks
actually i was trying tto find the month feb and sep.

dorst622@...


""Martijn Tonies"" <m.tonies@...> wrote in message
news:004801c27ffd$7317aca0$0a02a8c0@seal...

> 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."
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>