Re: Select data for current week only

you need to group dates per number week

2009/8/27 Edwin Plauchu <pianodaemon(at)gmail(dot)com>

> Postgresql has these functions
> http://www.postgresql.org/docs/8.1/static/functions-formatting.html for
> formatting data time
>
>
> 2009/8/27 BlackMage <dsd7872(at)uncw(dot)edu>
>
>
>> Hey all,
>>
>> I've been trying to figure this problem out with just using sql but I'm
>> not
>> sure how too. I have a table that holds events for each week but I only
>> want
>> to select events happening for the current week(Mon-Sun). So can anyone
>> help
>> me out with this just using sql? I've accomplished it sorta using php but
>> only within the current 7 day range(example Thursday-Thursday) but not by
>> the week.
>>
>> The field I am using for sorting is a Date type with the format yyyy-mm-dd
>> hh:mm:ss .
>> --
>> View this message in context:
>> http://www.nabble.com/Select-data-for-current-week-only-tp25177178p25177178.html
>> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>