Convert Unix Epoch Time to format HH:MM:SS without the date

Posted by user293249 on Stack Overflow See other posts from Stack Overflow or by user293249
Published on 2010-04-30T00:39:53Z Indexed on 2010/04/30 0:47 UTC
Read the original article Hit count: 471

Filed under:

ssrs-2005

|

epoch

|

convert

|

unix

|

time

I'm using SSRS 2005 and I need to convert time from a serial unix time like 3412.254263 to a duration like 166:12:35 where the second format is HH:MM:SS.

All .NET code should work, but I can't find any function that does not include the date or does not treat the result as a duration.

Any help would be appreciated!

© Stack Overflow or respective owner

Related posts about ssrs-2005

Error in Visual Studio 2008 with SSRS 2005 report projects

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone found a good workaound for opening or editing an SSRS 2005 report project with Visual Studio 2008 yet? Will the SQL server 2008 tools be the migration path for these report projects in the future? I really dont want to have to keep VS2005 installed forever just to update SSRS reports… >>> More
SSRS 2005 tabs/newline characters display in table

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How can i get a column in an SSRS 2005 report to render control chars like new lines and tabs? For example: SELECT VW.System_name + CHAR(13) + CHAR(9) + ' > ' + VW.PTS_NAME + CHAR(13) + CHAR(9) + CHAR(9) + ' > ' + VW.FEED_NAME as Name In SSRS (and SSMS Results to Grid Mode) table… >>> More
SSRS 2005 - Cascading parameters and default value update problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a report with cascading parameters. The first parameter is Finanical Period Type, being either Month or Week. The second parameter is a list of either financial months or weeks depending on what was selected for the first parameter. This all works well and selecting a series of different Financial… >>> More
How do I convert an INT into HH:mm:ss using SSRS 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Ok I need to display total talk time of an agent that is coming into SRSS 2005 from SQL 2005 as an INT. For the life of me I cannot figure out what combination of expression editing or format editing I need to use. For the detail portion I can use: =DATEADD("s", SUM(Fields!Talk_Time.Value), CDate("00:00")) And… >>> More
How to pass Multivalued parameters through URL in SSRS 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I have main matrix report and I want to navigate my sub report from main report by Jump To URL:(Using below JavaScript function) method. ="javascript:void(window.open('http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fKonsolidata_Data_Exporting_Project%2fEXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields… >>> More

Related posts about epoch

Epoch is not epoch if do a new Date(0L). Why ?

as seen on Stack Overflow - Search for 'Stack Overflow'
My problem is pretty straigtforward explained : if i do this : public class Main { public static void main(String[] args) throws Exception { Date d = new Date(0L ); System.out.println(d); } } I get the following output : Thu Jan 01 01:00:00 CET 1970 According to the doc, i… >>> More
Python 3: timestamp to datetime: where does this additional hour come from?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using the following functions: # The epoch used in the datetime API. EPOCH = datetime.datetime.fromtimestamp(0) def timedelta_to_seconds(delta): seconds = (delta.microseconds * 1e6) + delta.seconds + (delta.days * 86400) seconds = abs(seconds) return seconds def datetime_to_timestamp(date… >>> More
Convert epoch time to iso8601 format using jQuery

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to convert an epoch time (seconds since midnight 1/1/1970) to iso8601 format combined date and time in UTC ("2010-03-14T09:12Z" or "Tue Mar 14 21:02:31 +0000 2010") using jQuery code in a plugin. Any help greatly appreciated. Thanks! >>> More
Get seconds since epoch in any POSIX compliant shell

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to know if there's a way to get the number of seconds since the UNIX epoch in any POSIX compliant shell, without resorting to non-POSIX languages like perl, or using non-POSIX extensions like GNU awk's strftime function. Here are some solutions I've already ruled out... date +%s //… >>> More
unix date, number of seconds since epoch

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to use unix date to print the number of seconds since epoch? I'm open to using other standard shell commands if there is a way (I'm using Solaris, so there isn't date "+"%s") Thanks >>> More