# Creating a Time Based Column Filter in Treasure Console

Using the Treasure Console, you can convert Unix time columns to columns of type timestamp using the Data Workbench segment editor.

## Prerequisites

* Only columns that contain Unix time can be converted to timestamp. Unix time is stored as a 10-digit number (e.g. 1691244585). In the Treasure Console, these Unix time columns are usually of type long or string.
* You have already created a parent segment. See [Creating Parent Segments](/products/customer-data-platform/data-workbench/parent-segments/creating-parent-segments).


## Limitations

* Treasure Data does not support "all columns" set to true in the Parent Segment’s behavior configuration. Instead, choose "columns".


## Configuring a Timestamp Column

1. Log in to the Treasure Console.
2. Select **Data Workbench > Master Segments**.
3. Select the parent segment you want to use.
4. In the Attribute Table or Behavior Table sections, locate the column you want to configure.
5. If the column you want to configure is not displayed, you can select the **+** icon and then choose the column that you want to configure.


Columns that are eligible to be converted will have a checkbox next to them in the Timestamp section. Here is an example of a datetime_viewed column that can be converted to timestamp.

![](/assets/datetime_viewed.9a0e39007547bb6495f4755d12c8dec006239bcf113567fd224720381c0b0eab.cf3845cb.png)

1. Select the checkbox next to the column you want to convert to timestamp.
2. Select **Save**.


You can now filter that column using [Timestamp Operators in Audience Studio](/products/customer-data-platform/audience-studio/segment/rule-operator/timestamp-operators-in-audience-studio).

![](/assets/tdconsoletimebasedoperator.a2101625958c428cf0a92271828b34a86817292699262cfc2e47d965e3492212.cf3845cb.png)

## Copying Parent Segments with Converted Columns

When using the "Save As" feature in Treasure Console to copy or clone a Parent Segment that contains converted time columns, the timestamp data type will be preserved.

## Reverting Converted Timestamp Columns

If you need to revert a column that you converted to timestamp back to its previous type, you can use the Data Workbench segment editor to delete the column and select Save. Then you can re-add the column, which will have been reverted to its original data type.