SQL Timestamp literal parameter values consist of the keyword TIMESTAMP followed by a timestamp enclosed in single quotes with the format YYYY-MM-DD HH:MM:SS. Time zones are not supported on SQL Timestamp literal parameters. When dragging a literal Timestamp parameter into a variable, the following tree element is created.
A default timestamp of the current date and time is provided, but can be changed via the Properties panel. Double-click on Timestamp (CurrentDate CurrentTime) or highlight and click 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.
Date and Time — Either the standard windows Calendar control (reached by selecting the pull-down arrow of the selector) can be used to set the desired date by clicking through the months in the calendar using the < and > buttons, or the date can be set by just typing in the desired values for the month, day and year, one at a time.
To specify the time portion of the Date and Time fields, highlight the hours, minutes and/or seconds and type in the desired values.