How to convert an Timestamp 2012/10/20 09:45 to an alphanumeric format ? Am an begineer. pls help me .
Thanks MalathiThis message has been edited. Last edited by: Kerry,
WebFOCUS 7.6,7.7 Windows, All Outputs
November 23, 2012, 03:27 PM
Francis Mariani
The quickest and best method is to use the magical FPRINT function (DATE1 is your date column, DATE1_CONV is the converted column):
DEFINE FILE CAR
DATE1/HYYMDS = DT(&DATEYYMD 15:43:29);
DATE1_CONV/A19 = FPRINT(DATE1, 'HYYMDS', 'A19');
END
TABLE FILE CAR
PRINT
DATE1
DATE1_CONV
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
