| Subject | Re: date (day, month) from the YEARDATE |
|---|---|
| Author | legrand_legrand_63 |
| Post date | 2006-09-24T09:36:58Z |
--- In firebird-support@yahoogroups.com, "Petr Jakes" <petr@...> wrote:
select cast('01/01/2006' as timestamp)+32-1 from dual
rem:
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
http://www.fyracle.org/downloads/diff152.zip for those you would like
to create and UDF
Regards
PAscal
>try with somthing like
> 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
>
select cast('01/01/2006' as timestamp)+32-1 from dual
rem:
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
http://www.fyracle.org/downloads/diff152.zip for those you would like
to create and UDF
Regards
PAscal