Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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?

-Neal Lindsay


pgsql-novice by date

Next:From: Joel BurtonDate: 2001-07-31 14:45:18
Subject: Re: ----??? Random ???
Previous:From: Einar KarttunenDate: 2001-07-31 14:09:07
Subject: Re: Re: Re: Re: RANDOM function?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group