Click here to Skip to main content
15,395,065 members
Home / Discussions / Database
   

Database

 
AnswerRe: BLOB or external storage... Pin
Jörgen Andersson26-Jan-15 22:13
professionalJörgen Andersson26-Jan-15 22:13 
AnswerRe: BLOB or external storage... Pin
Richard Deeming27-Jan-15 1:50
mveRichard Deeming27-Jan-15 1:50 
GeneralRe: BLOB or external storage... Pin
Jörgen Andersson27-Jan-15 3:06
professionalJörgen Andersson27-Jan-15 3:06 
AnswerRe: BLOB or external storage... Pin
deepakdynamite28-Jan-15 0:30
Memberdeepakdynamite28-Jan-15 0:30 
QuestionDatediff function Pin
Ambertje26-Jan-15 2:18
MemberAmbertje26-Jan-15 2:18 
AnswerRe: Datediff function Pin
Chris Quinn26-Jan-15 2:25
MemberChris Quinn26-Jan-15 2:25 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 2:34
MemberAmbertje26-Jan-15 2:34 
GeneralRe: Datediff function Pin
Chris Quinn26-Jan-15 2:42
MemberChris Quinn26-Jan-15 2:42 
That is because you are storing empty strings, not null values. You also have two empty times, which wil cause problems with the query.

You also should not store dates and times as strings - use the DateTime column type provided to hold them properly.

SQL
declare @t table(START_DATE DateTime, END_DATE DateTime)
insert @t values ('01-jan-2015 20:12:52', Null)

select Datediff(SECOND,[START_DATE], ISNULL([END_DATE],[START_DATE]))
from @t

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

GeneralRe: Datediff function Pin
Ambertje26-Jan-15 3:12
MemberAmbertje26-Jan-15 3:12 
GeneralRe: Datediff function Pin
Chris Quinn26-Jan-15 3:18
MemberChris Quinn26-Jan-15 3:18 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 3:26
MemberAmbertje26-Jan-15 3:26 
GeneralRe: Datediff function Pin
Jörgen Andersson26-Jan-15 21:17
professionalJörgen Andersson26-Jan-15 21:17 
AnswerRe: Datediff function Pin
PIEBALDconsult26-Jan-15 5:57
professionalPIEBALDconsult26-Jan-15 5:57 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 22:21
MemberAmbertje26-Jan-15 22:21 
GeneralRe: Datediff function Pin
Corporal Agarn27-Jan-15 3:46
professionalCorporal Agarn27-Jan-15 3:46 
GeneralRe: Datediff function Pin
Ambertje3-Feb-15 5:36
MemberAmbertje3-Feb-15 5:36 
GeneralRe: Datediff function Pin
Ambertje27-Jan-15 0:03
MemberAmbertje27-Jan-15 0:03 
QuestionAccess query convert to MSSQL query Pin
Ray Raymos24-Jan-15 9:12
MemberRay Raymos24-Jan-15 9:12 
AnswerRe: Access query convert to MSSQL query Pin
Mycroft Holmes24-Jan-15 12:49
professionalMycroft Holmes24-Jan-15 12:49 
QuestionERD fee management system keep the record of whole year Pin
Haidar ali23-Jan-15 17:04
MemberHaidar ali23-Jan-15 17:04 
AnswerRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan23-Jan-15 22:45
mveRichard MacCutchan23-Jan-15 22:45 
GeneralRe: ERD fee management system keep the record of whole year Pin
Mycroft Holmes23-Jan-15 23:09
professionalMycroft Holmes23-Jan-15 23:09 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan23-Jan-15 23:20
mveRichard MacCutchan23-Jan-15 23:20 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 7:41
MemberHaidar ali24-Jan-15 7:41 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 7:42
MemberHaidar ali24-Jan-15 7:42 

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.