How to find the difference between two time using sql query of different datatype?

Question

1.89/5 (3 votes)

See more:

SQL-Server-2005

, +

Hai friends,

Actually my problem is that,i have to subtract two different time which stored in database as nvarchar using query string. main problem is that cast convertion is error. how to subtract two different NVARCHAR values of time using query string?
Anybody please help me.... if you are having any doubts regarding question please ask me..

Posted 26-Feb-14 19:07pm

Helen Paulose

Updated 26-Feb-14 19:18pm

King Fisher

v4

Add a Solution

Comments

[no name] 27-Feb-14 1:21am

Can you enter the sample data that you wants to use for substraction

Helen Paulose 27-Feb-14 2:15am

i have to subtract 01:00:00 and 02:00:00 which is stored in the database as nvarchar

[no name] 27-Feb-14 2:52am

DECLARE @FROMTIME VARCHAR(50)='02:00:00:00'
DECLARE @TOTIME VARCHAR(50)='01:00:00:00'

SELECT CONVERT(VARCHAR,((CONVERT(DATETIME,@FROMTIME,114) - CONVERT(DATETIME,@TOTIME,114))),114)

Solved your problem

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-02-26T20:19:00

Solution 2

No details, no direct help/answer.

Please, use SearchBox[^] on the right-top corner of this site. There are tons of examples.
Please be more specific and provide more details next time. It should be: 1) sample data and 2) expected output, at least.

Posted 26-Feb-14 20:19pm

Maciej Los

JoCodes · Answer 2 · 2014-02-26T19:33:00

Solution 1

Its always advised to keep Date datatype instead of NVarchar when handling dates.

Anyways you can try DATEDIFF method with a Convert to accomplish it.

Something like

SQL

Select DATEDIFF (MINUTE,DateColumn1,DateColumn2) from TableName;//without using Convert or Cast

Posted 26-Feb-14 19:33pm

JoCodes

Updated 26-Feb-14 19:57pm

v2