Focal Point
[SOLVED] Decimal time to HH:MM:SS

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/506107764

June 16, 2010, 02:04 PM
Riya
[SOLVED] Decimal time to HH:MM:SS
Can anyone let me know how to convert Decimal(6) to hh:mm:ss format.

DB field value 81515 (Decimal Val) to 8:15:15.

Thanks in advance
Riya

This message has been edited. Last edited by: Kerry,


WebFOCUS 8.1.05
Excel, PDF, Pivot, HTML
Windows
June 16, 2010, 02:14 PM
Doug
EDIT it.
June 16, 2010, 02:24 PM
Francis Mariani
Ha! Good one Doug!

Like a fool, I went the long route:

DEFINE FILE CAR
DB_TIME/I6 = 81515;

DATE1/A8 = '20000101';
TIME1/A6 = EDIT(DB_TIME);

ALPHA_DATE_TIME/A20 = DATE1 | TIME1;
DT_FROM_ALPHA/HYYMDS = HINPUT(14, ALPHA_DATE_TIME, 8, 'HYYMDS');

TIME/HHIS = DT_FROM_ALPHA;
END

TABLE FILE CAR
PRINT 
DATE1
TIME1
ALPHA_DATE_TIME
DT_FROM_ALPHA
TIME
BY COUNTRY
END



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
June 16, 2010, 02:25 PM
Riya
Thanks Doug,
Just wondering if we already have any date function to do that instead of converting it to Alpha and edit it to hours, mins,sec.

Cheers
Riya


WebFOCUS 8.1.05
Excel, PDF, Pivot, HTML
Windows
June 16, 2010, 02:32 PM
Francis Mariani
Date-Time functions require a date and a time, they don't work with just time.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
June 16, 2010, 03:10 PM
Riya
quote:
DB_TIME/I6 = 81515;

DATE1/A8 = '20000101';
TIME1/A6 = EDIT(DB_TIME);

ALPHA_DATE_TIME/A20 = DATE1 | TIME1;
DT_FROM_ALPHA/HYYMDS = HINPUT(14, ALPHA_DATE_TIME, 8, 'HYYMDS');

TIME/HHIS = DT_FROM_ALPHA;
END


Excellent That works! I totally forgot that i was just using time not Date-time.

Thank you Francis


WebFOCUS 8.1.05
Excel, PDF, Pivot, HTML
Windows