Click here to Skip to main content
15,617,358 members
Home / Discussions / Database
   

Database

 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Eddy Vluggen4-Sep-14 8:26
professionalEddy Vluggen4-Sep-14 8:26 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Jörgen Andersson4-Sep-14 10:57
professionalJörgen Andersson4-Sep-14 10:57 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Eddy Vluggen4-Sep-14 11:54
professionalEddy Vluggen4-Sep-14 11:54 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Jörgen Andersson4-Sep-14 18:39
professionalJörgen Andersson4-Sep-14 18:39 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Corporal Agarn5-Sep-14 0:51
professionalCorporal Agarn5-Sep-14 0:51 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Richard Deeming5-Sep-14 1:50
mveRichard Deeming5-Sep-14 1:50 
AnswerRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Corporal Agarn4-Sep-14 0:55
professionalCorporal Agarn4-Sep-14 0:55 
AnswerRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Richard Deeming4-Sep-14 1:41
mveRichard Deeming4-Sep-14 1:41 
As others have said, the time should be part of the DATE_CREATED column. However, it's still possible to get what you need:
SQL
WHERE
    (DATE_CREATED = '20140902' And Convert(time, TIME_CREATED) >= '05:00:00')
Or
    (DATE_CREATED = '20140903' And Convert(time, TIME_CREATED) <= '05:00:00')




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Ambertje4-Sep-14 1:46
Ambertje4-Sep-14 1:46 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Corporal Agarn4-Sep-14 3:06
professionalCorporal Agarn4-Sep-14 3:06 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
sai sruthi8-Sep-14 23:38
sai sruthi8-Sep-14 23:38 
AnswerRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
challa naresh kumar reddy12-Sep-14 2:31
challa naresh kumar reddy12-Sep-14 2:31 
QuestionSend email from a stored procedure Pin
Member 12847213-Sep-14 12:26
Member 12847213-Sep-14 12:26 
AnswerRe: Send email from a stored procedure Pin
GuyThiebaut3-Sep-14 21:46
professionalGuyThiebaut3-Sep-14 21:46 
GeneralRe: Send email from a stored procedure Pin
Member 12847214-Sep-14 17:49
Member 12847214-Sep-14 17:49 
GeneralRe: Send email from a stored procedure Pin
GuyThiebaut4-Sep-14 21:30
professionalGuyThiebaut4-Sep-14 21:30 
GeneralRe: Send email from a stored procedure Pin
jschell5-Sep-14 10:34
jschell5-Sep-14 10:34 
AnswerRe: Send email from a stored procedure Pin
Eddy Vluggen3-Sep-14 22:35
professionalEddy Vluggen3-Sep-14 22:35 
AnswerRe: Send email from a stored procedure Pin
Corporal Agarn4-Sep-14 0:57
professionalCorporal Agarn4-Sep-14 0:57 
AnswerRe: Send email from a stored procedure Pin
Sibeesh KV24-Sep-14 18:49
professionalSibeesh KV24-Sep-14 18:49 
QuestionHow to calculate annual leave - please advise Pin
Jassim Rahma3-Sep-14 11:18
Jassim Rahma3-Sep-14 11:18 
AnswerRe: How to calculate annual leave - please advise Pin
Jassim Rahma3-Sep-14 12:03
Jassim Rahma3-Sep-14 12:03 
AnswerRe: How to calculate annual leave - please advise Pin
Richard MacCutchan3-Sep-14 21:35
mveRichard MacCutchan3-Sep-14 21:35 
QuestionHTML content to be formatted Pin
Karan_TN31-Aug-14 19:07
Karan_TN31-Aug-14 19:07 
SuggestionRe: HTML content to be formatted Pin
Kornfeld Eliyahu Peter31-Aug-14 19:30
professionalKornfeld Eliyahu Peter31-Aug-14 19:30 

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.