Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do you substr a datetime field?
Message
De
03/09/1998 11:00:21
 
 
À
02/09/1998 16:29:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00132460
Message ID:
00132793
Vues:
15
>>>>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform