Home > mailing lists

Re: Dates in postgres - Mailing list pgsql-novice

From	Josh Berkus
Subject	Re: Dates in postgres
Date	February 25, 2002 15:18:07
Msg-id	web-800782@davinci.ethosmedia.com Whole thread Raw
In response to	Dates in postgres (Rob <rob@obsidian.co.za>)
List	pgsql-novice

Tree view

Rob,

> I can get today's date in postgres using the current_date function,
>  but I
> need to get the date one month ago from the current date.  Is there
>  any
> way to do this?

See:
http://techdocs.postgresql.org/techdocs/faqdatesintervals.php

-Josh

pgsql-novice by date:

From: "David J. Lines"
Date: 25 February 2002, 14:51:00
Subject: Major newbie

From: Tom Lane
Date: 25 February 2002, 16:08:26
Subject: Re: Array as a parameter in user-defined functions

Re: Dates in postgres - Mailing list pgsql-novice

Previous

Next