On Tue, 2005-05-03 at 12:32, Craig Bryden wrote: > 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? select now()-interval'1 hour' and so on. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings