Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any reason to store time in 8-char field?
Message
 
 
À
01/05/2008 22:27:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01314637
Message ID:
01314925
Vues:
8
>>>I don't see why it should be 5 characters when 4 is enough. :)
>>I get your point but I will still use 5. I just like the way this colon (:) looks in my field. Kind of like a double smile :)
>>
>
>I'd argue for keeping the seconds: Murphy says the sooner you ditch them, the sooner you will need them.
>Calculating differences is another point to consider: if you keep your fields datetime this reduces risk of own errors.
>If strapped for space (laaarge table with a couple of dozen such fields) I'd save seconds() in an integer field (recalc still easy), if really strapped for space (already nearing 2GB) I'd map minute count to a 2 byte char field.
>
>my 0.02 EUR
>
>thomas

Thomas,

Thank you very much for your input.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform