Postgres Pro
Downloads
Home   >   mailing lists

Re: skip weekends: revisited - Mailing list pgsql-general

From Jeff Amiel
Subject Re: skip weekends: revisited
Date
Msg-id 4235CE04.5060908@istreamimaging.com
Whole thread Raw
In response to Re: skip weekends: revisited  (Andre Maasikas <andre.maasikas@abs.ee>)
List pgsql-general
Tree view 
Andre Maasikas wrote:

> From the looks of it, variable date seems to calculate
> the first day of a week and for it to work day_of_the_week
> has to start from 0 so Sunday - 0,  Friday - 5
> (in US at least?)
>
> Andre

That appears to be the case (0 is sunday.....)
thanks for the assist!!

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: prelimiary performance comparison pgsql vs mysql
Next
From: Chris Travers
Date:
Subject: Re: sql question