pc.mt
Mask time conversion.
Syntax
mt{{h}{s}}
Description
invokes the time conversion function to convert external time representations to internal format or to convert internal time values to one of a variety of external time formats.
The 'internal' time format is the number of seconds from midnight. The 'external' time is 24-hour military format (e.g., 23:25:59) or 12-hour format (e.g., 11:25:59PM).
For input-conversion, the time is entered with 'AM' or 'PM' immediately following the numeric time. If none is entered, 'AM' is assumed. On output, 'AM' or 'PM' is always printed immediately following the numeric time.
Note: '12:00AM' is considered midnight. '12:00PM' is considered noon. 'AM' and 'PM' are ignored on input if the 'mt' code is specified. Illegal values are converted to null on input.
When used as an input-conversion, the 'mt' code validates the time and converts it to the internal format of seconds from midnight. When updating a field controlled by an 'mt' conversion, the '/' (slash) character can be used to insert the current time into the attribute.
'h' specifies a 12 hour clock. Default is (military) 24 hour clock.
's' includes seconds in output value. If 's' is omitted, seconds are not listed on output.
Example
data conversion ouput
3600 mt 01:00
3600 mth 01:00am
3600 mts 01:00:00
3600 mths 01:00:00am
46800 mt 13:00
46800 mth 01:00pm
3630 mts 01:00:30
46800 mths 01:00:00pm
See Also
User Comments
What do you think?
Share your experience or ask a question by using the form below.
Login to leave your comments.
