Re: [Firebird-devel] WEEK as date difference

[Richard W. <haw...@ta...>]

On 13 Apr 2008, at 06:38, Claudio Valderrama C. wrote:
> Hello, the word WEEK seems to be used exclusively in the standard  
> to mean
> "the week position inside the year", hence it can go between 1 and  
> 52. This
> is the way we use it inside FB: it only can be used with EXTRACT.
>
> Do you see any problem if I reuse WEEK inside dateAdd and dateDiff?  
> This
> means that you add a full week to a date/datetime in dateAdd or you  
> get the
> difference between two dates/datetimes in weeks in dateDiff. For  
> me, it's a
> convenience to not have to write
> weeks := trunc(second_timestamp - first_timestamp) / 7;
> because I can write
> weeks := datediff(week from first_timestamp to second_timestamp);
> etc.


Would this be in 2.1 or 2.5?

________________________________________________________
Richard Wesley          Senior Software Developer            Tableau  
Software
Visit: http://www.trytableau.com/now.html