How To add time in hr:min:Sec format in sql query

Question

1.00/5 (1 vote)

See more:

In my web application i have to insert the time (hr:min:sec format) taken to complete a sum to database. If a person doing the same problem for the second time then our time must add. That means if the time taken to complete a sum for the first time is 01:10:55 and if the same sum is doing again with a time of 01:25:10, then i have to add both the time (the time ll b 02:36:05).i have to insert this time to database. What type of datatype should i use.

help me to do this in sql server 2008 stored procedure....

Posted 18-Feb-13 18:10pm

shamjid

Updated 10-Mar-13 20:25pm

v3

Add a Solution

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)

*Karthik Harve* · Answer 1 · 2013-02-18T18:21:00

Hi,

probably, the datatype of your table column is smalldatetime. change that to "DateTime". this will provide accuracy up to milliseconds. And insert the value using "GETDATE()" function, which will give complete date with time. Ex. 2013-02-19 10:44:36.410, with seconds and milliseconds.

SQL

INSERT INTO TableName (ColumnName) VALUE(GETDATE())

hope it helps

Khorshed Alam, Dhaka · Answer 2 · 2013-02-19T00:24:00

Hi,
From your description above this could be a solution.

SQL

DECLARE @T TABLE (AttemptDiff TIME)

DECLARE @FirstTry        DATETIME,
        @SecondTry       DATETIME,
        @DiffSeconds     INT

SET @FirstTry = GETDATE()

WAITFOR DELAY '00:00:05' --Assume user attempt for second try  after 5 seconds

SET @SecondTry = GETDATE() --grab the second try

SET @DiffSeconds = DATEDIFF(SECOND, @FirstTry, @SecondTry) --get the difftime

--SELECT @DiffSeconds

--SELECT @FirstTry

SET @FirstTry = DATEADD(second, @DiffSeconds, @FirstTry) --Add it to the first try

INSERT INTO @T
SELECT CONVERT(VARCHAR, @FirstTry, 108) -- Insert it to table.


SELECT * FROM @T t

This solution could work fro SQL Server 2012 for other version keep the time as varchar.

Enjoy!!!

How To add time in hr:min:Sec format in sql query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0