The Totp() function calculates a time-based one-time password based on the given secret and given UTC time.
WIKI: https://en.wikipedia.org/wiki/Time-based_one-time_password
MyWEM Forum: https://my.wem.io/forum?threadid=184
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a text value based on the given secret and UTC time, containing 6 numbers.
Returns Unknown if one of the parameter values is unknown or outside the common valid boundaries. May throw a Server500 error when the secret is NOT a proper Base32 value with characters from the collection "ABCDEFGHIJKLMNOPQRSTUVWXYZ234567"
| Name | Type | Required | Description |
|---|---|---|---|
secret
Base32 text
secret the password is based on. Must be base32 encoded and must contain any of the characters from the collection as indicated in the syntax example.
date
date time
UTC time or time and interval the password is based on.