Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Milliseconds
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01433836
Message ID:
01433857
Views:
75
>>>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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform