Hi Evan,
>time arithmetic 2:32pm - 7:00am = ??
Datetime formats a subtractable, adn the result is in Numeric type. But a date would be required to make this somewhat safe to use
Examples
1. 9/23/99 11:40 AM - 9/22/99 11:40 PM
This would show up as -12 if not for the dates
2. 2:00 PM - 1:30 PM
30 minutes right? maybe its 24 hrs 30 min, or 48 hrs and 30 min
>storing of time value in table without having to convert to either numeric or datetime format
VFP will return a difference between times (datetime() - datetime()) in seconds which happens to be of numeric type, so that would have to change (otherwise you would have to convert it, which is what you want to avoid).
>ability to make global time format changes across app
Can't this happen know? I'm not positive.
>easy validation of well and poorly contructed time
I don't understand this one. You mean by user input?
I could think of other enhancements to Time related function, however:
?SECONDS([ttTime])
for example, where ttTime is any time DateTime format and it returns the seconds past midnight. This wouldn't be as useful now as it was before you could directly subtract T types (or could you always?).
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement