SQL Time literal parameter values consist of the keyword TIME followed by a time enclosed in single quotes with the format HH:MM:SS. Time zones and fractional seconds are not supported. When dragging a literal Time parameter into a variable, the following tree element is created.
Variable Creation > Input > Variables: SQL Elements pane - Literal Parameters > Time
A default time midnight is provided, but can be changed via the Properties panel. Double-click on Time (00:00:00) or highlight and click Properties.
Variable Creation > Input > Variables: SQL Elements pane - Literal Parameters > Time Properties
- Parameter — Either ‘<NewParameter>’ may be selected, or an existing parameter may be selected via the pull-down list.
- Name — When ‘<NewParameter>’ is selected, the Name of the new parameter may be entered here. The name must be unique among all parameters defined in the analysis.
- Description — A description of the parameter may be entered here. It should be limited to 512 characters if the analysis is ever to be published to the Model Manager application.
- Time — You can highlight the hours, minutes and seconds individually and type in the desired values, or use the up and down arrows on the selector to access valid values for each.