Use this field level rule to format a time for different localities using data retrieved from an extract record based on the mask you select. This rule supports overflow.
The mask for the FmtTime rule takes these values:
There are two types of format masks, pre-defined types (1, 2, 3 and 4) and user-defined format arguments. If the pre-defined formats meet your needs, simply use them, otherwise, you can create a user-defined format.
For information on using pre-defined format types, see Using Pre-Defined Time Formats.
User-defined format arguments consist of one or more codes, each preceded by a percent sign (%). For more information on user-defined format masks, see Setting Up Format Arguments.
You can enter up to 80 characters in the mask.
Assume the extract file contains the time 132045, which is 20 minutes and 45 seconds past 1 pm.
The format mask of:
T, “1”, T, “2:”
formats the time using the pre-defined format “2:” and generates 01:20:45 PM as output.
The format mask of:
T, “1”, T, “%H hours and %M minutes”
formats the time using a custom format and generates 13 hours and 20 minutes as output.
© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.