Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you substr a datetime field?
Message
From
02/09/1998 16:29:06
 
 
To
02/09/1998 16:27:12
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00132460
Message ID:
00132528
Views:
12
>>>>>I want to display and edit the time part of the datetime field.
>>>>>How can I substr the time part?
>>>>
>>>>? substr(ttoc(datetime()),10)
>>>thanks Ed -
>>>thanks work
>>>?substr(ttoc(date_time),11)
>>>the display is : 12:45:00 AM
>>>Now I want to take off the last two zeros and just display and edit
>>>this :12:45 ?
>>
>>Open help and read about SUBSTR(), please.
>-------
>hey ed..
>I have a fld call time_val and is a ch 8. In this field I have an Input Mask
>of 99:99 !! - I would like the !! to be either AM or PM. Can you help with this.
>thanks :)

You better use two separate textboxes.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform