[CLOSED] Time to String conversion

Focal Point

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

December 03, 2009, 10:58 AM

ramakrk

[CLOSED] Time to String conversion

Hi
I have DB2,input column is Time 03:53:00, i need to convert this into String format.My goal is calculate the difference between previous and current time.Any help really appreciated.
rama

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

WebFOCUS 762
Windows
To be decided(All formats)

December 03, 2009, 11:35 AM

GinnyJakes

You might want to check out the function HCNVRT which converts date-time to alpha.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

December 03, 2009, 12:43 PM

Darin Lee

If you're wanting time difference, use the HDIFF function which uses date-time formats. No need to convert to string.

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat