[CLOSED] Convert Alphanumeric format to Integer format
Hi, I am trying to display time along the Y axis in the format hh.mi .
-SET &ECHO = ALL; SQL SQLORA SET SERVER OMNI.PERSHING.COM; SQL SQLORA SET DATETIME ON;
SQL SQLORA
SELECT TO_NUMBER(TO_CHAR(TIME_DURATION,'SSSSS'))AS "metric1", timestamp AS TIMECOL FROM OMNI_USER.INTRADAY_VOLUMES_FACT A,OMNI_USER.DATE_DIMENSION B WHERE (TIMESTAMP,COUNT) IN ( SELECT TIMESTAMP,MAX(COUNT) FROM OMNI_USER.INTRADAY_VOLUMES_FACT A, OMNI_USER.DATE_DIMENSION B,OMNI_USER.BUSINESS_DRIVER_DIMENSION_DIM C WHERE A.DATE_KEY = B.DATE_KEY AND A.BUSINESS_DRIVER_DIMENSION_KEY = C.BUSINESS_DRIVER_DIMENSION_KEY AND DRIVER_NAME = 'Intraday ATOMS Orders' AND TIMESTAMP >= TO_DATE('09/01/2008','mm/dd/yyyy') AND TIMESTAMP <= TO_DATE['09/30/2008','mm/dd/yyyy') GROUP BY TIMESTAMP) AND A.DATE_KEY = B.DATE_KEY;
SQL SQLORA END SESSION;
TABLE FILE SQLOUT
PRINT
metric1/I4
AND COMPUTE TRANSDATE/YYMD = HDATE(TIMECOL, 'YYMD'); TIMELINE/MDY=TRANSDATE;
AND COMPUTE -* Below line extracts the HOUR HOUR/I2 = metric1/3600; HR_R/I2 = metric1-(HOUR* 3600); -* Below line extracts the MINUTE MIN/I2 = (HR_R / 60); -* Display the Output in HH;MI format HHMI/A8 = EDIT(HOUR) ||'.'|| EDIT(MIN); -* Here I want to convert the Alphanumeric format back to Integer format so that I can plot this in the Y axis of the Graph -* But this line again display only the HOUR part. HHMI_Int/I7 = EDIT(HHMI); ON TABLE HOLD AS QOUT END
TABLE FILE QOUT PRINT metric1 HOUR MIN HHMI HHMI_Int TIMELINE END