Date addition/subtraction

From: "Craig Bryden" <postgresql(at)bryden(dot)co(dot)za>
To: "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: Date addition/subtraction
Date: 2005-05-03 17:32:20
Message-ID: 000f01c55006$10816af0$0200a8c0@amd2800
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Franco Bruno Borghesi 2005-05-03 17:39:48 Re: Date addition/subtraction
Previous Message Robert Fitzpatrick 2005-05-03 17:29:03 Sorting by constant values