> I work in a hospital and need to make a program that counts the amount
> of people interned per day. I have in a mysql database the day that the
> person interned and the day that it leaves.
> tHow can I count that the person is interned in the middle days??? I
> need to make a graph of that.

"Ricardo Luceac" <rluceac@gmail.com> wrote in message
news:eslC0nYdHHA.4984@TK2MSFTNGP05.phx.gbl...
>
>
> Hi all...
>
> I know this isn't the right place for that but i'm with this problem..
>
>
> I work in a hospital and need to make a program that counts the amount
> of people interned per day. I have in a mysql database the day that the
> person interned and the day that it leaves.
> tHow can I count that the person is interned in the middle days??? I
> need to make a graph of that.

Michael C wrote:
> SELECT COUNT(*) FROM SomeTable WHERE DateIn <= GetDate()AND (DateOut >=
> GetDate() OR DateOut IS NULL)
>
> I'm not sure what the function is in mysql to get the current date, in
> SQLServer it is GetDate().

Rune Jacobsen wrote:
> Michael C wrote:
>> SELECT COUNT(*) FROM SomeTable WHERE DateIn <= GetDate()AND (DateOut
>> >= GetDate() OR DateOut IS NULL)
>>
>> I'm not sure what the function is in mysql to get the current date, in
>> SQLServer it is GetDate().
>
> In MySQL the function is now().
>
> If you also want to see how many were admitted per date in a certain
> timespan, you could do something like this (psuedo-SQL):
>
> SELECT count(*) AS numpatients, DATE(DateIn) AS interned
> FROM SomeTable
> WHERE DATE(DateIn) <= 'Start date' AND Date(DateIn) >= 'Stop date'
> GROUP BY DATE(DateIn)
>
> Not tested, but shouldn't be far off. :)
>
> Rune

Göran Andersson wrote:
> Well, it's close, but it's also the total opposite. ;)
>
> WHERE DATE(DateIn) >= 'Start date' AND Date(DateIn) <= 'Stop date'
>