Datetime/Timestamp Operations

Datetime/Timestamp Operations are applied at the column level

Column-level operations available on Datetime and Timestamp-type columns — format, calculate, convert, encode, copy, mask, and hash.

Datetime/Timestamp operations apply to columns with a Datetime or Timestamp data type. Access them by clicking the column menu icon (≡) on any such column header in the Table view.

The following operations are available:

Operation	Description
Format	Converts the datetime value to a specified format.
Calculate	Performs datetime arithmetic — add, subtract, compute differences, or extract date parts.
Case	Applies conditional logic to produce a derived value.
Encode	Buckets datetime values and encodes each bucket with a provided value.
Copy	Copies the column into a new column.
Convert	Converts the datetime value to another data type (String).
Mask	Masks the datetime value — fully or partially.
1-way Hash	Computes a one-way hash of the datetime value (SHA 256 or SHA 512).