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. Thanks! _________________________________________________________________ Got Game? Win Prizes in the Windows Live Hotmail Mobile Summer Games Trivia Contest http://www.gowindowslive.com/summergames?ocid=TXT_TAGHM
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
------------------------------------------------------------------------- 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@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@cwi.nl
participants (2)
-
Elad . -
Niels Nes