[Monetdb-developers] DateAdd()

Niels Nes Niels.Nes at cwi.nl
Mon Aug 4 12:45:24 CEST 2008


On Mon, Aug 04, 2008 at 08:40:33AM +0000, Elad . wrote:
> 
>    Hi,
> 
>    Is there an existing SQL implementation of the DateAdd function
>    in Monetdb?  Something along the lines of SELECT DATEADD(month,
>    1, '08/30/2006') that would add a single month to the specified
>    time stamp.

select date '2006-08-30' + interval '1' month ;

Niels
> 
>    Thanks!
>      __________________________________________________________
> 
>    Got Game? Win Prizes in the Windows Live Hotmail Mobile Summer
>    Games Trivia Contest [1]Find out how.
> 
> References
> 
>    1. http://www.gowindowslive.com/summergames?ocid=TXT_TAGHM

> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers


-- 

Niels Nes, Centre for Mathematics and Computer Science (CWI)
Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
room C0.02,  phone ++31 20 592-4098, fax ++31 20 592-4312
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl




More information about the developers-list mailing list