Click here to Skip to main content
16,016,477 members
Home / Discussions / Database
   

Database

 
QuestionRe: Employee Year Calculation Pin
Eddy Vluggen10-Sep-14 10:07
professionalEddy Vluggen10-Sep-14 10:07 
AnswerRe: Employee Year Calculation Pin
Kornfeld Eliyahu Peter10-Sep-14 10:20
professionalKornfeld Eliyahu Peter10-Sep-14 10:20 
QuestionMySQL CREATE EVENT Question Pin
Jassim Rahma8-Sep-14 23:08
Jassim Rahma8-Sep-14 23:08 
AnswerRe: MySQL CREATE EVENT Question Pin
Eddy Vluggen9-Sep-14 8:51
professionalEddy Vluggen9-Sep-14 8:51 
QuestionArabic langauge not display when i make search by arabic langauge why Pin
ahmed_sa5-Sep-14 20:44
ahmed_sa5-Sep-14 20:44 
AnswerRe: Arabic langauge not display when i make search by arabic langauge why Pin
Bernhard Hiller7-Sep-14 22:25
Bernhard Hiller7-Sep-14 22:25 
AnswerRe: Arabic langauge not display when i make search by arabic langauge why Pin
Richard Deeming8-Sep-14 2:02
mveRichard Deeming8-Sep-14 2:02 
QuestionSelect records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Ambertje4-Sep-14 0:07
Ambertje4-Sep-14 0:07 
Hello everyone,

Can someone help me select rows between 2 dates en between 2 times.
I need to select all records from 02/09/2014 starting from time 05:00:00 until the next day time until 05:00

If I do it like this then it wont work, no records shows:

SQL
SELECT TOP 10000 *
FROM Staging.[dbo].AD
WHERE DATE_CREATED BETWEEN '02/09/2014' and '03/09/2014'
AND Convert(Time,TIME_CREATED) between '05:00:00' AND '05:00:00'



It should be something like this:
Between DATE_CREATED 02/09/2014, TIME_CREATED 05:00:00 and DATE_CREATED 03/09/2014, TIME_CREATED 05:00:00

Kind regards,
Ambertje
AnswerRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Chris Quinn4-Sep-14 0:13
Chris Quinn4-Sep-14 0:13 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Ambertje4-Sep-14 1:40
Ambertje4-Sep-14 1:40 
AnswerRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Eddy Vluggen4-Sep-14 0:31
professionalEddy Vluggen4-Sep-14 0:31 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Ambertje4-Sep-14 1:41
Ambertje4-Sep-14 1:41 
QuestionRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Richard MacCutchan4-Sep-14 6:19
mveRichard MacCutchan4-Sep-14 6:19 
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 
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 

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.