Re: [SQL] Fun with Dates

2012-10-29 Thread Mark Fenbers
Or the other way round: anything that is equal or greater than the first of the current month: select ... from foobar where obstime >= date_trunc('month', current_date); I knew it had to be something si

Re: [SQL] Fun with Dates

2012-10-29 Thread Thomas Kellerer
Mark Fenbers wrote on 29.10.2012 23:38: Greetings, I want to be able to select all data going back to the beginning of the current month. The following portion of an SQL does NOT work, but more or less describes what I want... ... WHERE obstime >= NOW() - INTERVAL (SELECT EXTRACT (DAY FROM NOW