Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Datetime
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00397324
Message ID:
00397327
Vues:
11
>I have a database that contains a 5 character field for 24 hour clock which is entered as hh:mm . I have a seperate date field in date format mm/dd/yyyy.
>
>I would like to combine both of these into the foxpro datetime format.
>
>Suggestions?

Sure:

tdatetime = DATETIME(YEAR(ddate), MONTH(ddate), DAY(ddate), VAL(LEFT(ctime, 2)), VAL(RIGHT(ctime, 2)))

Of course, this is VFP 6.0.
George

Ubi caritas et amor, deus ibi est
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform