Thank you Stefran. I in expert in pentaho. If you need anything of pentaho, i can help you. i im trying to do testing as MonetDB as 300 millions of rows. Do you know hardware requirements for this amounts of data? 2013/12/2 Stefan Manegold <Stefan.Manegold@cwi.nl>

select extract ( year from now() - interval '1' month );

Edgar Mejia <omejiasq@gmail.com> wrote:

...

i need to know how to subtract one month the current date. For example in postgres i can to do it so: extract('year' from current_date - interval '1 month') . How i can to do this as monetdb?

Thanks

------------------------------

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | Database Architectures (DA) | | www.CWI.nl/~manegold | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |