Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Precision of DateTime fields
Message
 
To
20/02/1997 17:55:02
Jacques Mainguy
Platinum Visual Data Systems
Calgary, Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00021441
Message ID:
00021569
Views:
27
>We are converting a FoxPro 2.6 application that used FPSQL.FLL to retrieve info. from SQL-Server tables into Visual FoxPro 5.0.
>
>FPSQL retrieved DateTime fields with a precision of 1/1000th. of a second. We don't seem to be able to get more than a second in precision with VFP 5.0. Is there any way to get better?
>
>Thanks.
>
>Jacques Mainguy.

Not sure what the precision of date/time field is. You can use the seconds() function and store that to a charcter field. Is a bit of a pain in string manipulation in coding but you can get to 1/1000th second easily.

HTH
Todd Burstain, MD
infinitydoc@delphi.com
Previous
Reply
Map
View

Click here to load this message in the networking platform