Click here to Skip to main content
15,506,023 members
Home / Discussions / Database
   

Database

 
QuestionRe: Employee Year Calculation Pin
Eddy Vluggen10-Sep-14 11:07
professionalEddy Vluggen10-Sep-14 11:07 
AnswerRe: Employee Year Calculation Pin
Kornfeld Eliyahu Peter10-Sep-14 11:20
professionalKornfeld Eliyahu Peter10-Sep-14 11:20 
QuestionMySQL CREATE EVENT Question Pin
Jassim Rahma9-Sep-14 0:08
Jassim Rahma9-Sep-14 0:08 
AnswerRe: MySQL CREATE EVENT Question Pin
Eddy Vluggen9-Sep-14 9:51
professionalEddy Vluggen9-Sep-14 9:51 
QuestionArabic langauge not display when i make search by arabic langauge why Pin
ahmed_sa5-Sep-14 21:44
ahmed_sa5-Sep-14 21:44 
AnswerRe: Arabic langauge not display when i make search by arabic langauge why Pin
Bernhard Hiller7-Sep-14 23:25
Bernhard Hiller7-Sep-14 23:25 
AnswerRe: Arabic langauge not display when i make search by arabic langauge why Pin
Richard Deeming8-Sep-14 3:02
mveRichard Deeming8-Sep-14 3:02 
QuestionSelect records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Ambertje4-Sep-14 1:07
Ambertje4-Sep-14 1: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 1:13
Chris Quinn4-Sep-14 1:13 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Ambertje4-Sep-14 2:40
Ambertje4-Sep-14 2:40 
AnswerRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Eddy Vluggen4-Sep-14 1:31
professionalEddy Vluggen4-Sep-14 1:31 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Ambertje4-Sep-14 2:41
Ambertje4-Sep-14 2:41 
QuestionRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Richard MacCutchan4-Sep-14 7:19
mveRichard MacCutchan4-Sep-14 7:19 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Eddy Vluggen4-Sep-14 9:26
professionalEddy Vluggen4-Sep-14 9:26 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Jörgen Andersson4-Sep-14 11:57
professionalJörgen Andersson4-Sep-14 11:57 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Eddy Vluggen4-Sep-14 12:54
professionalEddy Vluggen4-Sep-14 12:54 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Jörgen Andersson4-Sep-14 19:39
professionalJörgen Andersson4-Sep-14 19:39 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Corporal Agarn5-Sep-14 1:51
professionalCorporal Agarn5-Sep-14 1:51 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Richard Deeming5-Sep-14 2:50
mveRichard Deeming5-Sep-14 2:50 
AnswerRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Corporal Agarn4-Sep-14 1:55
professionalCorporal Agarn4-Sep-14 1:55 
AnswerRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Richard Deeming4-Sep-14 2:41
mveRichard Deeming4-Sep-14 2:41 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Ambertje4-Sep-14 2:46
Ambertje4-Sep-14 2:46 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
Corporal Agarn4-Sep-14 4:06
professionalCorporal Agarn4-Sep-14 4:06 
GeneralRe: Select records between day, time 05:00:00 and day+1 until time 05:00:00 Pin
sai sruthi9-Sep-14 0:38
sai sruthi9-Sep-14 0: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 3:31
challa naresh kumar reddy12-Sep-14 3: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.