Home > mailing lists

Date addition/subtraction - Mailing list pgsql-general

From	Craig Bryden
Subject	Date addition/subtraction
Date	May 3, 2005 17:30:07
Msg-id	000f01c55006$10816af0$0200a8c0@amd2800 Whole thread Raw
Responses	Re: Date addition/subtraction Re: Date addition/subtraction Re: Date addition/subtraction Re: Date addition/subtraction
List	pgsql-general

Tree view

Hi

How in postgres can I do date/time subtraction or addition.
e.g. If I want to get today's date - 30 days? or current_timestamp - 1 hour?

Thanks
Craig

pgsql-general by date:

From: Robert Fitzpatrick
Date: 03 May 2005, 17:29:35
Subject: Sorting by constant values

From: Franco Bruno Borghesi
Date: 03 May 2005, 17:39:52
Subject: Re: Date addition/subtraction

Date addition/subtraction - Mailing list pgsql-general

Previous

Next