Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using datetime in its compressed state
Message
De
25/01/2006 16:31:16
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01090298
Message ID:
01090308
Vues:
7
>Is there a way to utilize the datetime data type in its compressed state? In a table it only requires 8 bytes to store what displays as 19 characters or 14 characters if you remove the non-numeric chars. I want to create a unique character string that incorporates the datetime value plus the rightmost 3 chars from the seconds() function. I looked at using the Julian date, but it does not have the time part that I need. If there is a simpler, better way of doing this, please let me know. Thanks for any help you can give.
>Colombo.
? 0H+BINTOC(DATETIME()-{^1899-12-30:},"8")
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform