Timestamp Substitution Format Specifier

Timestamp substitution format specifiers allows explicit control of the format applied when substituting a timestamp value. These specifiers can be used with {hvr_cap_tstamp[spec] }, {hvr_integ_tstamp[spec]}, and {colname [spec]} if colname has timestamp data type. The substitutions {hvr_cap_tstamp[spec]}, {,hvr_integ_tstamp[spec]}, and {colname [spec]} are available in the following action parameters:

The components that can be used in a timestamp format specifier are:

Component

Description

Example

%a

Abbreviate weekday according to current locale.

Wed

%b

Abbreviate month name according to current locale.

Jan

%d

Day of month as a decimal number (01–31).

07

%H

Hour as number using a 24–hour clock (00–23).

17

%j

Day of year as a decimal number (001–366).

008

%m

Month as a decimal number (01 to 12).

04

%M

Minute as a decimal number (00 to 59).

58

%s

Seconds since epoch (1970–01–01 00:00:00 UTC).

1099928130

%S

Second (range 00 to 61).

40

%T

Time in 24–hour notation (%H:%M:%S).

17:58:40

%U

Week of year as decimal number, with Sunday as first day of week (00 – 53).

30

%V

Linux

The ISO 8601 week number, range 01 to 53, where week 1 is the first week that has at least 4 days in the new year.

15

%w

Weekday as decimal number (0 – 6; Sunday is 0).

6

%W

Week of year as decimal number, with Monday as first day of week (00 – 53)

25

%y

Year without century.

14

%Y

Year including the century.

2014

%[localtime]
  Since    v5.5.5/xx  

Perform timestamp substitution using machine local time (not UTC). This component should be at the start of the specifier (e.g. {{hvr_cap_tstamp %[localtime]%H}}).

%[utc]
  Since    v5.5.5/xx  

Perform timestamp substitution using UTC (not local time). This component should be at the start of the specifier (e.g. {{hvr_cap_tstamp %[utc]%T}}).