Subject Re: date (day, month) from the YEARDATE
Author legrand_legrand_63
--- In, "Petr Jakes" <petr@...> wrote:
> Hi,
> I would like to know if there is a way to get day and month form the
> YEARDAY number? (searching archive didn't get solution)
> for example:
> 1 => Jan-1 (or 01.01.)
> 32 => Feb-1 (or 02.01.)
> regards
> Petr Jakes

try with somthing like
select cast('01/01/2006' as timestamp)+32-1 from dual

Oracle provides TO_DATE('032','DDD') for this purpose.
This feature is available with fyracle the firebird oracle-mode.

C++ Source code can be found in btc.cpp at for those you would like
to create and UDF