Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DATETIME() from the server
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00777291
Message ID:
00778490
Vues:
31
>Date and Time are stored in different columns of the array returned by ADIR() and they are different datatypes. Date last modified is Date and Time last modified is Character. How can I combine them into a DATETIME that can be inserted into a DATETIME field of a table?

Doug,

There're many ways to do that. Here's one
ldDate = DATE()
lcTime = TIME()
? DTOT(ldDate) + VAL(LEFT(lcTime,2)) * 60*60 + ;
		VAL(SUBSTR(lcTime,4,2)) * 60 + VAL(RIGHT(lcTime,2))
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform