Subject | Re: days from January the 1st |
---|---|
Author | csswa |
Post date | 2002-03-02T13:13:55Z |
extract(year from current_date) || '-01-01'
will give you the string, which you can cast as date or use with your
days calculation -- if this is what you meant.
Regards,
Andrew
will give you the string, which you can cast as date or use with your
days calculation -- if this is what you meant.
Regards,
Andrew
--- In ib-support@y..., Duilio Foschi <dedalus@y...> wrote:
> Helen,
>
> >It's not far out:
> >gg = :d_mov - cast('2002-01-01' as date);
>
> I realize I didn't express myself clearly.
>
> My problem is (mainly) to replace '2002-01-01' with some function
that
> returns the 1st January of the _current year_.
>
> Or next year I will have to replace _my code_ with '2003-01-01'...
>
> TYIA
>
> Duilio