Re: [SQL] current_date / datetime stuff

[Gerardo Herzig]

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:

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend