>>>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