On Fri, Sep 28, 2007 at 01:11:54AM -0700, pawan123 wrote:

how we get the timestamp value 10 minutes before from current_timestamp

select current_TIMESTAMP - INTERVAL '10' minute; Niels

_________________________________________________________

View this message in context: [1]how we get the timestamp value 10 minutes before from current_timestamp Sent from the [2]monetdb-users mailing list archive at Nabble.com.

References

1. http://www.nabble.com/how-we-get-the-timestamp-value-10-minutes-before-from-... 2. http://www.nabble.com/monetdb-users-f4367.html

------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- 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