Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you substr a datetime field?
Message
From
03/09/1998 11:00:21
 
 
To
02/09/1998 16:29:06
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00132460
Message ID:
00132793
Views:
14
>>>>>>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.
thanks ed.. I forgot I posted this quetion and posted it again..
Robert Keith
Independent Developer
San Antonio, Texas
E-mail address:
rebelrob1@yahoo.com
Previous
Reply
Map
View

Click here to load this message in the networking platform