Sql 2008:concatenate two or more string and display them in a single record

Question

0.00/5 (No votes)

See more:

I have a column with date-time and i want to add then display all the time from the start till the end as one record:

For example:

SQL

DelayTime:
1900-01-01 02:30:50.000
1900-01-01 03:20:10.000
1900-01-01 02:40:00.000
1900-01-01 00:10:00.000
1900-01-01 03:00:00.000
1900-01-01 06:20:00.000
1900-01-01 05:00:00.000
1900-01-01 01:00:00.000
1900-01-01 01:59:20.000
1900-01-01 00:04:00.000
1900-01-01 00:60:00.000
1900-01-01 00:30:00.000
1900-01-01 08:00:00.000
1900-01-01 09:30:00.000
1900-01-01 10:00:00.000
1900-01-01 03:35:00.000

Then Display as:

DelayTime:
The total time of Delaye
00:00:00

Only,Is it possible?

Posted 24-Apr-13 1:56am

Puseletso Michelle

Updated 24-Apr-13 2:17am

v5

Add a Solution

Comments

ZurdoDev 24-Apr-13 7:59am

You want all those records to show as 00:00:00? Or, are you wanting to add up the times? Please be more clear.

gvprabu 24-Apr-13 7:59am

see u need to find the delay time or... what is ur expected Output. Question is not clear. give some more explaination.

Puseletso Michelle 24-Apr-13 7:59am

To show as 00:00:00

[no name] 24-Apr-13 8:00am

Yes it is possible.

gvprabu 24-Apr-13 8:01am

Give some actual Data with proper Date and Time and Sample Output also.

Puseletso Michelle 24-Apr-13 8:01am

can you please show me the code to do so?

Sudhakar Shinde 24-Apr-13 8:05am

Your previous query was related to selecting a distinct record which included date as well as time part. Now you want to display only time part but you want to select distinct record.

e.g. if your data is as follows..
1900-01-01 00:00:00.000
1900-01-01 00:00:00.000
1900-01-01 01:01:00.000
1900-01-01 02:02:00.000
Then you want to display
00:00:00
01:01:00
02:02:00

Is this understanding correct?

Puseletso Michelle 24-Apr-13 8:11am

on your example: add all the time,then it will
Display 03:03:00

that will be the total time of your example!

gvprabu 24-Apr-13 8:26am

Fist give some more clear explaination.

2 solutions

Solution 1

select 'DelayTime: The total time of Delaye 00:00:00'

Posted 24-Apr-13 2:11am

Sant Osha

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)

TrushnaK · Accepted Answer · 2013-04-24T02:51:00

Solution 2

You can't use SUM on a DateTime and varchar column.

If your final goal is to get sum of all datadiff records in hh:mm:ss then stored the difference in minutes as:-

SQL

SELECT DATEDIFF(second,CAST('02:32:00' AS DATETIME)
, CAST('03:40:00' AS DATETIME))/60.0 AS MIN_DIFF;

Then to do sum of all minutes in hh:mm:ss then use:-

SELECT CONVERT(CHAR(8), DATEADD(Minute,convert(int, 68), '00:00:00'), 108)

Posted 24-Apr-13 2:51am

TrushnaK

Comments

gvprabu 24-Apr-13 8:59am

First of all what is his actual requirement also we don't know.. :-)

Puseletso Michelle 24-Apr-13 9:33am

@Trushnak Thanks Excatly what am looking for :-)

TrushnaK 24-Apr-13 10:12am

Most Welcome...

TrushnaK 24-Apr-13 10:13am

@gvprabhu read the conversion above between Sudhakar Shinde and Puseletso Michelle you clear about problem..