get_month_from_timestamp¶
Syntax¶
Parameters¶
<timestamp>- An expression representing a timestamp, formatted as either
YYYYMMDDHHorYYYYMMDD.
Returns¶
The month value (an integer) of the given timestamp.
Description¶
This action extracts and returns the month defined by a given timestamp. The
timestamp must be formatted as either YYYYMMDDHH or YYYYMMDD, where YYYY
is a four-digit year, MM is a two-digit month, DD is a two-digit day, and
HH is a two-digit hour.
A timestamp that exceeds the 10-character format will evaluate the final 10
digits as a timestamp. That is, get_month_from_timestamp(20205069787654321)
returns \(65\).
A malformed timestamp that does not represent an actual date will not raise an error.
Examples¶
The following returns 1 since this timestamp represents January 2, 2021 at 12 noon.