Supported Trip Codes for Times
Trip codes are case sensitive. If you need to specify a trip code, use the case that is indicated in the table below.
The format for a time trip sequence is %T<format>%, where <format> contains one or more of the trip codes listed below. The resulting time is affected by the Trip Sequence Time field on the SQL Export Form (see Specify the Trip Sequence Time).
Geo SCADA Expert supports these trip codes for time strings in an SQL Export’s Output File Name (see Specify the Name of the Output File):
Trip Sequence | Description | Example |
---|---|---|
h |
The hour in the day, using a 12-hour clock. Leading zeros are excluded for single-digit hours. |
3 |
hh |
The hour in the day, using a 12-hour clock. Leading zeros are included for single-digit hours. |
03 |
H |
The hour in the day, using a 24-hour clock. Leading zeros are excluded for single-digit hours. |
3 15 |
HH |
The hour in the day, using a 24-hour clock. Leading zeros are included for single-digit hours. |
03 15 |
m |
The minutes past the hour. Leading zeros are excluded for single-digit minutes. |
4 |
mm |
The minutes past the hour. Leading zeros are included for single-digit minutes. |
04 |
s |
The seconds past the minute. Leading zeros are excluded for single-digit seconds. |
9 |
ss |
The seconds past the minute. Leading zeros are included for single-digit seconds. |
09 |
t |
A one-character string, A or P, to indicate whether the time is before or after midday. |
A |
tt |
A two-character string, AM or PM, to indicate whether the time is before or after midday. |
AM |
Example:
The code
%THH:mm:ss%
displays a time in the form
14:25:06