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... :)

Any hint ?

TYIA

Duilio Foschi