You could select a PADL(LEFT(TTOC(DateTimeField,2),5),5,'0') and get "09:00" in both instances.

>I am having problem with a form. In a test form using a Visual FoxPro BASECLASS FORM. I can do the following query and it works OK:
>
>SELECT LEFT(TTOC(DateTimeField,2),5) FROM Table
>
>and the results are for 9AM I get "09:00."
>
>However, in a form using my class library I get "9:00:" instead.
>
>The second form is a PRIVATE DATASESSION.
>
>Apparantly this looks to be a PRIVATE DATASESSION issue!
>
>Any IDEAS?
>
>TIA