> inside a SP, I need to compute the number of days that have elapsed since
> January the 1st of the current year up to a given date (also of the current
> year).
>
> For now, I have been able to write
>
> gg=cast(:d_mov-'2002-01-01' as integer);
>
> but the bluff won't last long... :)

Dialect 3?

If so, CAST ( EXTRACT YEAR AS DATE ) for the '2002-01-01'
entry.

I havn't switched to 3 yet so I'm not sure of the details
<g>

If not 3, then you probably need a UDF to do the extract.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services