you need to group dates per number week 2009/8/27 Edwin Plauchu <pianodae...@gmail.com>
> Postgresql has these functions > http://www.postgresql.org/docs/8.1/static/functions-formatting.html for > formatting data time > > > 2009/8/27 BlackMage <dsd7...@uncw.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@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >
