Click here to Skip to main content
15,850,446 members
Home / Discussions / Database
   

Database

 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 3:34
Ambertje26-Jan-15 3:34 
GeneralRe: Datediff function Pin
Chris Quinn26-Jan-15 3:42
Chris Quinn26-Jan-15 3:42 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 4:12
Ambertje26-Jan-15 4:12 
GeneralRe: Datediff function Pin
Chris Quinn26-Jan-15 4:18
Chris Quinn26-Jan-15 4:18 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 4:26
Ambertje26-Jan-15 4:26 
GeneralRe: Datediff function Pin
Jörgen Andersson26-Jan-15 22:17
professionalJörgen Andersson26-Jan-15 22:17 
AnswerRe: Datediff function Pin
PIEBALDconsult26-Jan-15 6:57
mvePIEBALDconsult26-Jan-15 6:57 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 23:21
Ambertje26-Jan-15 23:21 
Good morning to you all,


It's Start_Date and Start_Time that can be empty.
So I think ISNULL(Start_Date, Start_Time) is what I need.

How can I implement this in my code?
SQL
,Datediff(SECOND,
     convert(datetime, [START_DATE] + ' ' + [START_TIME]),
     convert(datetime, [END_DATE] + ' ' +   END_TIME]))                                                  AS M_Time_Worked


Kind regards,
Ambertje
GeneralRe: Datediff function Pin
Corporal Agarn27-Jan-15 4:46
professionalCorporal Agarn27-Jan-15 4:46 
GeneralRe: Datediff function Pin
Ambertje3-Feb-15 6:36
Ambertje3-Feb-15 6:36 
GeneralRe: Datediff function Pin
Ambertje27-Jan-15 1:03
Ambertje27-Jan-15 1:03 
QuestionAccess query convert to MSSQL query Pin
Ray Raymos24-Jan-15 10:12
Ray Raymos24-Jan-15 10:12 
AnswerRe: Access query convert to MSSQL query Pin
Mycroft Holmes24-Jan-15 13:49
professionalMycroft Holmes24-Jan-15 13:49 
QuestionERD fee management system keep the record of whole year Pin
Haidar ali23-Jan-15 18:04
Haidar ali23-Jan-15 18:04 
AnswerRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan23-Jan-15 23:45
mveRichard MacCutchan23-Jan-15 23:45 
GeneralRe: ERD fee management system keep the record of whole year Pin
Mycroft Holmes24-Jan-15 0:09
professionalMycroft Holmes24-Jan-15 0:09 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan24-Jan-15 0:20
mveRichard MacCutchan24-Jan-15 0:20 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 8:41
Haidar ali24-Jan-15 8:41 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 8:42
Haidar ali24-Jan-15 8:42 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan24-Jan-15 8:47
mveRichard MacCutchan24-Jan-15 8:47 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 8:55
Haidar ali24-Jan-15 8:55 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan24-Jan-15 9:06
mveRichard MacCutchan24-Jan-15 9:06 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali25-Jan-15 1:04
Haidar ali25-Jan-15 1:04 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan25-Jan-15 2:03
mveRichard MacCutchan25-Jan-15 2:03 
QuestionNeed a Select query that filter illegal characters Pin
nainakarri21-Jan-15 20:14
nainakarri21-Jan-15 20:14 

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.