Re: current_date / datetime stuff

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: current_date / datetime stuff
Date: 2007-06-05 18:01:26
Message-ID: 4665A4F6.8040501@fmed.uba.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

We should have a onliner contest. I love oneliners!!!

> oneliner:
>
> select date_trunc('month',now()) + ((8 - extract('dow' from date_trunc
> ('month',now()))||'days')::text)::interval;
>
> Kristo
> On 04.06.2007, at 19:39, Michael Glaesemann wrote:
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Charles.Hou 2007-06-05 23:59:21 Re: the right time to vacuum database?
Previous Message Marko Kreen 2007-06-05 16:35:29 Re: Encrypted column