From: | Dmitry Tkach <dmitry(at)openratings(dot)com> |
---|---|
To: | Jake Stride <nsuk(at)users(dot)sourceforge(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Date Iteration |
Date: | 2003-07-09 22:18:37 |
Message-ID: | 3F0C94BD.8060503@openratings.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Well...
Something like 'same day next week' (now () + '1 weeks') or 'same date
next month' (now () + '1 months') etc is simple.
Stuff like 'next Monday' is messier - the simplest thing I could think of is
now () + '1 weeks' - (date_part ('dow', now()) || ' days') + '1 days'
::interval (for next Monday for example) or
now () + '1 months' - (date_part ('day', now()) || 'days') + '25
days'::interval (for the 25th next month)
etc.
Something like crond is much better suited for caledars then plain old
sql :-)
Dima
Jake Stride wrote:
>I am currently writing a calendar application and need to figure out on
>which days recurring events occur. I basically have a table with start
>and end dates and a recurrence type (eg/ day/week/month plus a few
>others).
>
>Therefore I would like to be able to work out (for example) the date of
>every monday between the start and end dates or every 25th day of the
>month etc. Is there an (easy) way to do this, or do I need to write a
>function to do it?
>
>Thanks
>
>Jake
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Nabil Sayegh | 2003-07-10 02:04:09 | Re: HelpDesk System ??? |
Previous Message | Dmitry Tkach | 2003-07-09 19:26:58 | Re: inheritance |