Dividing (and rounding) a date?

From: Neal Lindsay <neal(dot)lindsay(at)peaofohio(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Dividing (and rounding) a date?
Date: 2001-07-31 14:25:03
Message-ID: 5.1.0.14.0.20010731100938.00a127d0@mail.peaofohio.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am trying to create a query that, given a date, will return the
beginning-of-pay-period date. Our pay periods last two weeks and begin on
Mondays. I can't seem to divide or find the modulus of any date or
interval types. Does anyone have any suggestions?

Thanks
-Neal Lindsay

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Joel Burton 2001-07-31 14:45:18 Re: ----??? Random ???
Previous Message Einar Karttunen 2001-07-31 14:09:07 Re: Re: Re: Re: RANDOM function?