Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any reason to store time in 8-char field?
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01314637
Message ID:
01314650
Views:
14
I don't see why it should be 5 characters when 4 is enough. :)

>
>I need to store time in a new field (I don't use TimeDate field yet). I don't really need to store seconds; hours and minutes is all I need. So, initially, I am thinking of making the new field 5 char long (e.g. "02:12"). But I am wondering, can someone offer a reason(s), why it might be better to create this field as 8 characters and store the seconds, even though I won't use them now. In the future update I will convert this database to a SQL Server and probably will combine another DATE field with this new TIME field into one DateTime.
>
>Thank you in advance for any input.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform