Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DateTime Native Format?
Message
 
To
29/09/2016 13:41:14
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01641508
Message ID:
01641511
Views:
66
>>I'm wanting to store a datetime as compactly as possible. When you create a datetime field in a table, it takes 8 bytes but if you do a TTOC(), it takes 20 characters. Is there a way of getting that 8 byte value from the DBF and easily convert it back and forth?
>
>I don't understand what you're asking. Storing as DateTime is the compact way.
>
>Tamar

I should have been clearer - I need to store this as a text field in a lookup table holding all my settings. I was hoping to store it in a few characters without making up my own scheme.
Kogo Michael Hogan

"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?

Ideate Web Site
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform