<div>
select convert(char(8),dateadd(s,<wbr />duration,'<wbr />19000101')<wbr />,108)<br />
<br />
so add the duration to 1st jan 1900<br />
then convert it back to character using format 108 which is just time....<br />
<br />
should work as long as duration is less than 24hours...<br />
<br />

</div>


select convert(char(8),dateadd(s,duration,'19000101'),108)

so add the duration to 1st jan 1900
then convert it back to character using format 108 which is just time....

should work as long as duration is less than 24hours...



<div>
Oops,<br />
Sorry Lowfatspread for duplicate post
</div>


Oops,
Sorry Lowfatspread for duplicate post

<div>
@allicia,<br />
Lowfatspread was the first to come with the solution,<br />
mine is exactly the same although the syntax slightly differs<br />
'19000101' is the 'root' date and is stored internally as 0<br />
I feel miserable for getting the points that LFS deserved<br />
<br />
@LFS<br />
my apologies again<br />
<br />
@both<br />
I'm OK for the points to be reaffected<br />
Or I can post a &quot;points for LFS&quot; question<br />
<br />
Thks<br />
<br />
Hilaire
</div>


@allicia,
Lowfatspread was the first to come with the solution,
mine is exactly the same although the syntax slightly differs
'19000101' is the 'root' date and is stored internally as 0
I feel miserable for getting the points that LFS deserved

@LFS
my apologies again

@both
I'm OK for the points to be reaffected
Or I can post a "points for LFS" question

Thks

Hilaire

<div>
no problem &nbsp;hilaire<br />
;-)<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi there,<br />
<br />
I have a table A with column duration (int) and I would like to view the duration (initially in seconds) in hh:mm:ss format.<br />
<br />
Example,<br />
<br />
Table A<br />
---------<br />
duration &nbsp; &nbsp; &nbsp; Expression1<br />
120 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 00:02:00<br />
110 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 00:01:50<br />
45 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 00:00:45<br />
3602 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01:00:02<br />
<br />
What is the sql statement to convert the seconds into the mentioned format (hh:mm:ss)?<br />
<br />
<br />
:O)
</div>
</div>


Hi there,

I have a table A with column duration (int) and I would like to view the duration (initially in seconds) in hh:mm:ss format.

Example,

Table A
---------
duration       Expression1
120             00:02:00
110             00:01:50
45               00:00:45
3602           01:00:02

What is the sql statement to convert the seconds into the mentioned format (hh:mm:ss)?


:O)

Change duration in seconds into hh:mm:ss format

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.