Home > mailing lists

interval is ignored - Mailing list pgsql-general

From	rodeored
Subject	interval is ignored
Date	June 15, 2009 19:48:48
Msg-id	b56ded5d-11e9-47d3-9194-3df7f805d215@x6g2000vbg.googlegroups.com Whole thread Raw
List	pgsql-general

Tree view

SELECT INTERVAL '1' MONTH = 00:00:00
 Therefore now=onemonthago
SELECT NOW(),NOW()- INTERVAL '1' MONTH as onemonthago

How do I get the timestamp for one month ago?

pgsql-general by date:

From: Mike Toews
Date: 15 June 2009, 19:39:34
Subject: Select ranges based on sequential breaks

From: rodeored
Date: 15 June 2009, 19:48:57
Subject: Re: interval is ignored

interval is ignored - Mailing list pgsql-general

Previous

Next