Postgres Pro
Downloads
Home   >   mailing lists

Re: current_date / datetime stuff - Mailing list pgsql-sql

From Gerardo Herzig
Subject Re: current_date / datetime stuff
Date
Msg-id 4665A4F6.8040501@fmed.uba.ar
Whole thread Raw
In response to Re: current_date / datetime stuff  (Kristo Kaiv <kristo.kaiv@skype.net>)
Responses Re: current_date / datetime stuff  ("Rodrigo De León" <rdeleonp@gmail.com>)
List pgsql-sql
Tree view 
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:
>

pgsql-sql by date:

Previous
From: "Oliveiros Cristina"
Date:
Subject: Re: JOIN
Next
From: "Rodrigo De León"
Date:
Subject: Re: current_date / datetime stuff