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?).
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only