Subject | Re: Dates calculations |
---|---|
Author | didiergm |
Post date | 2002-01-04T22:00:14Z |
Works perfect,
thanks
Didier
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]