Focal Point
[SOLVED] Decimal time to HH:MM:SS
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
DougEDIT it.
June 16, 2010, 02:24 PM
Francis MarianiHa! 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
RiyaThanks 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 MarianiDate-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
Riyaquote:
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