Click here to Skip to main content
14,358,929 members
   

Database

 
AnswerRe: checking whether today's date is public holiday Pin
Mycroft Holmes4-Mar-13 12:43
memberMycroft Holmes4-Mar-13 12:43 
GeneralRe: checking whether today's date is public holiday Pin
Member 87018134-Mar-13 22:28
memberMember 87018134-Mar-13 22:28 
GeneralRe: checking whether today's date is public holiday Pin
Member 87018134-Mar-13 22:41
memberMember 87018134-Mar-13 22:41 
QuestionActivate reminder for event to send email notification 3 days before event Pin
Member 87018133-Mar-13 7:01
memberMember 87018133-Mar-13 7:01 
AnswerRe: Activate reminder for event to send email notification 3 days before event Pin
Mycroft Holmes3-Mar-13 12:59
memberMycroft Holmes3-Mar-13 12:59 
AnswerRe: Activate reminder for event to send email notification 3 days before event Pin
Sandeep Mewara3-Mar-13 19:45
mentorSandeep Mewara3-Mar-13 19:45 
AnswerRe: Activate reminder for event to send email notification 3 days before event Pin
Davidduraisamy5-Mar-13 0:52
memberDavidduraisamy5-Mar-13 0:52 
Questionpeak hours query Pin
Jassim Rahma3-Mar-13 0:38
memberJassim Rahma3-Mar-13 0:38 
Hi,

I need a help please

I am using MySQL. I have a patients database. In patients database I have a table called visit with created_date field as timestamp datatype.

I want to do a query which will give the break down of total number of patients in every hour like this:

hour -------- Patients
00 -------- 7
01 -------- 8
02 -------- 11
03 -------- 4
...
...
...
20 -------- 5
21 -------- 10
22 -------- 3
23 -------- 0


Technology News @ www.JassimRahma.com

AnswerRe: peak hours query Pin
Mycroft Holmes3-Mar-13 13:02
memberMycroft Holmes3-Mar-13 13:02 
AnswerRe: peak hours query Pin
Bernhard Hiller3-Mar-13 21:39
memberBernhard Hiller3-Mar-13 21:39 
AnswerRe: peak hours query Pin
S Douglas4-Mar-13 10:49
professionalS Douglas4-Mar-13 10:49 
QuestionProblem closing patient file! Pin
Jassim Rahma2-Mar-13 22:34
memberJassim Rahma2-Mar-13 22:34 
AnswerRe: Problem closing patient file! Pin
Joezer BH2-Mar-13 22:50
professionalJoezer BH2-Mar-13 22:50 
GeneralRe: Problem closing patient file! Pin
Jassim Rahma2-Mar-13 23:24
memberJassim Rahma2-Mar-13 23:24 
GeneralRe: Problem closing patient file! Pin
Joezer BH2-Mar-13 23:29
professionalJoezer BH2-Mar-13 23:29 
AnswerRe: Problem closing patient file! Pin
Sandeep Mewara2-Mar-13 22:59
mentorSandeep Mewara2-Mar-13 22:59 
GeneralRe: Problem closing patient file! Pin
Jassim Rahma2-Mar-13 23:26
memberJassim Rahma2-Mar-13 23:26 
GeneralRe: Problem closing patient file! Pin
Sandeep Mewara2-Mar-13 23:44
mentorSandeep Mewara2-Mar-13 23:44 
AnswerRe: Problem closing patient file! Pin
gvprabu3-Mar-13 23:18
membergvprabu3-Mar-13 23:18 
QuestionSQLExpress scripted install Pin
loctrice2-Mar-13 1:26
professionalloctrice2-Mar-13 1:26 
AnswerRe: SQLExpress scripted install Pin
loctrice2-Mar-13 3:35
professionalloctrice2-Mar-13 3:35 
Generaldatabase Pin
Kapilkp1-Mar-13 1:16
memberKapilkp1-Mar-13 1:16 
GeneralRe: database Pin
Richard MacCutchan1-Mar-13 1:58
protectorRichard MacCutchan1-Mar-13 1:58 
GeneralHomework Pin
David Mujica1-Mar-13 4:31
memberDavid Mujica1-Mar-13 4:31 
GeneralRe: Homework Pin
Richard MacCutchan1-Mar-13 4:33
protectorRichard MacCutchan1-Mar-13 4:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.