Re: Extract dates of a given day

2018-04-06 Thread rob stone
Hello, On Fri, 2018-04-06 at 11:32 +0100, hmidi slim wrote: > Hi, > I have a table availability: id (integer), product varchar(255), > period (daterange) > I want to extract dates from a given period matching a given day. > E.g: for the period from 01/04/2018 - 30/04/2018 and for day = > Monday

Re: Extract dates of a given day

2018-04-06 Thread mariusz
On Fri, 2018-04-06 at 11:32 +0100, hmidi slim wrote: > Hi, > > I have a table availability: id (integer), product varchar(255), > period (daterange) > > I want to extract dates from a given period matching a given day. > > E.g: for the period from 01/04/2018 - 30/04/2018 and for day = Monday >

Extract dates of a given day

2018-04-06 Thread hmidi slim
Hi, I have a table availability: id (integer), product varchar(255), period (daterange) I want to extract dates from a given period matching a given day. E.g: for the period from *01/04/2018 - 30/04/2018* and for *day = Monday* I want to get *02/04/201809/04/201816/04/201823/04/201830/04/2018*