Generate and manipulate Universally Unique Lexicographically Sortable Identifiers.
x
(optional): An expression of any supported data type. The value is discarded, but the expression is used to bypass common subexpression elimination when the function is called multiple times in one query.FixedString(26)
value representing the generated ULID.
Example:
Generate a single ULID:
1
and 2
ensure that each generateULID()
call produces a distinct value.
ulid
(String
or FixedString(26)
): The input ULID.timezone
(String
, optional): The timezone name for the returned value.DateTime64(3)
]
Example:
taco_order_time
extracts the timestamp from a ULID representing a taco order.new_order_id
generates a new ULID for the next order.