Subject Re: Dates calculations
Author didiergm
Works perfect,

thanks
Didier

--- In ib-support@y..., "Roberto de Amorim" <rbamorim@i...> wrote:
> > I need to do some ageing calculations on finance transactions, and
> > have got several questions:
> >
> > A: How can I calculate the dateparts of a date (day, month, year). I
>
> Heve you been tested the "EXTRACT" command??
> try it:
>
> SELECT EXTRACT( MONTH FROM <table.date_field> AS MONTH_OF_DATE FROM
<TABLE>
>
>
>
>
>
> [Non-text portions of this message have been removed]