Think of a Timestamp as a real number, with the whole part representing days
since the Epoc (not sure when that is for Firebird).

So adding a day would be as simple as:

Select MyDate + 1
From MyTable;

From there, you should be able to figure out the rest.

Jason

d_dude_2003 wrote:

> I need to do various calculation with dates in my stored procedure
> code, such as add X years and substract Y days...
>
> Currently i am using UDFs, but is there a chance this can be done
> natively with Firebird SQL?
>
> Thanx.
>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--

The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.