Hai all..

I have been working on time field and partially successully..

I have a field in HYYMDS format and I extracted date using HDATE. I am working on how to extract time from this.
Can anyone help me on this?

I have one more time field in I11 format. how can I show this in 05:15:40 format?
I have seen reverse of this but not the above.
Please suggest me something..

Thanks..

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

I guess that I would try HPART to extract the hour, minute, and second components.

Click on 'Search the Technical Documenation Library' in the upper right of this screen for the syntax.

For the HYYMDS field, Jim is right - use HPART.
For the I11 field, it all depends on how the time is stored in that field.
It may be possible to convert it to a real date/time field, after which you could use the HPART again.
It may also be possible that the time in this field is already in there as required, only without the :. Then it would be enough to convert to alpha and add the : at the correct places.
Can't tell which direction to go without more info.