Subject Re: [firebird-support] Re: date functions in FB
Author Jason Dodson
Ok, I gave some direction. The fact that you can't do your own work is no fault
of Firebird. The Firebird (with Interbase) uses UDF's for added funtionality.
SQL Server has all of the date functions from VBA... well, because, it has
bindings to VBA.

Regardless, for all of the grateful people out there that care about this thread:

Select Cast(Extract(Month From MyDate) || '\' || Extract(Day from MyDate) || '\'
|| Extract(Year from MyDate) + 1) as Timestamp
From MyTable


d_dude_2003 wrote:
>>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.
> Adding years is not obvious at all. Years can contain different number
> of days and there should be functions to handle that....Why the FB SQL
> is so poor? I remember doing this with MS SQL very easily..

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.