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
(for 3am or 3pm)

hh

The hour in the day, using a 12-hour clock. Leading zeros are included for single-digit hours.

03
(for 3am or 3pm)

H

The hour in the day, using a 24-hour clock. Leading zeros are excluded for single-digit hours.

3
(for 3am)

15
(for 3pm)

HH

The hour in the day, using a 24-hour clock. Leading zeros are included for single-digit hours.

03
(for 3am)

15
(for 3pm)

m

The minutes past the hour. Leading zeros are excluded for single-digit minutes.

4
(for four minutes past the hour)

mm

The minutes past the hour. Leading zeros are included for single-digit minutes.

04
(for four minutes past the hour)

s

The seconds past the minute. Leading zeros are excluded for single-digit seconds.

9
(for nine seconds)

ss

The seconds past the minute. Leading zeros are included for single-digit seconds.

09
(for nine seconds)

t

A one-character string, A or P, to indicate whether the time is before or after midday.

A
(to indicate that a time is before midday)

tt

A two-character string, AM or PM, to indicate whether the time is before or after midday.

AM
(to indicate that a time is before midday)

Example:

The code

%THH:mm:ss%

displays a time in the form
14:25:06


Disclaimer

Geo SCADA Expert 2020