Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Milliseconds
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Divers
Thread ID:
01433836
Message ID:
01433857
Vues:
74
>>>When I do a insertion of a record I want to save not only the Timestamp like "HH;MM;SS" but I also want to store the microsecond part, since in 1 second a machine can store multiple records, ant I want to distinguish them by milli or microsecond.
>>
>>Why don't you let mysql handle it?
>>
>>
>>... ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
>>
>
>It doesn't appear that MySQL's Timestamp has precision below seconds..?

In that case OP will have to store datetime value as a string in order to preserve milliseconds part
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform