---
title: "Add the current date and time in Strata | Oplema"
description: "Add the current date or time as a one-row table with Date/Time Now in Strata. Choose the column name and a format such as ISO, DATE, TIMESTAMP or UNIX."
url: "https://oplema.com/docs/strata/io/date-time-now"
updated: "2026-11-04"
---

# Date/Time Now

Date/Time Now creates a table with one row and one column containing the current date or time. It needs no input table. Choose the column name and output format. Each run can give a different value.

**Learn this in context:** [Rolling date filter: last 7 days from today](https://oplema.com/learn/table-to-dashboard/filter-last-7-days) (Build and publish a dashboard)

## Create the current time

Date/Time Now has no input. Its preview shows the value calculated when this example ran in your browser.

Result
| DateTimeNow |
| --- |
| 2026-11-02 23:04:03.107 |

1. Change Column Name to `run_at` and look for the new heading in the output.
2. Choose `DATE` in Format to keep just the calendar date.
3. Switch Format to `ISO` or `UNIX` and compare the result with the formats below.

## When to use

Use Date/Time Now when a flow needs the current date or time, such as stamping a table with when it was prepared, or calculating how many days old each row is.

## Read the output

Date/Time Now creates a new table with one row and one column. Column Name sets the heading, and Format sets how the value looks and its data type.

The value is calculated when the block runs. The preview shows the result of one run and doesn't tick like a clock. Changing a setting can start a new run and give a different value.

To parse date or time values already present in a column, use [DateTime](https://oplema.com/docs/strata/parse/datetime).

## Inputs and outputs

### Inputs

0 ports

No input ports

This block has no incoming connection.

### Outputs

1 port

**Out**

A table with one row and one column containing the current date or time. Column Name sets the column heading, and Format sets the value and data type.

## Choose the value you need

Example values for September 9, 2026 at 12:34:56 UTC. The live example uses the current time, so its value will differ.

Date/Time Now output formats and illustrative values
| Format | Example value | Use it for |
| --- | --- | --- |
| UNIX VARCHAR | `1788957296000` | Milliseconds since the Unix epoch, returned as text. Convert to a number before doing numeric arithmetic. |
| ISO VARCHAR | `2026-09-09T12:34:56` | A readable date and time to the second. This string has no Z suffix or timezone offset. |
| DATE DATE | `2026-09-09` | The calendar date, without a time of day. Use it when the day is the level of detail you need. |
| TIME TIME | `12:34:56` | The current time of day in UTC, without a date. |
| TIMESTAMP TIMESTAMP | `2026-09-09 12:34:56` | A typed date and time for downstream date calculations. The value can include fractional seconds. |
| TIMESTAMP WITH TIME ZONE TIMESTAMP WITH TIME ZONE | `2026-09-09 12:34:56+00` | Dates with times, stored in UTC. |

## Configure the block

**Column Name**

Name of the produced column.

Default: `DateTimeNow`

**Format**

Type of the produced date or time value.

Default: `TIMESTAMP`

Options: UNIX, ISO, DATE, TIME, TIMESTAMP, TIMESTAMP WITH TIME ZONE.

## Date/Time Now FAQs

**Does Date/Time Now need an input table?**

No. It's a source block that creates its own table with one row and one column containing the current date or time.

**Does the timestamp update continuously?**

No. The value is calculated when the block runs. The preview shows the result of one run and doesn't tick like a clock. A later run can give a different value.

**Is UNIX measured in seconds or milliseconds?**

UNIX returns milliseconds since the Unix epoch as text. Convert that text to a numeric type if you need to calculate with it.

**Does ISO include a timezone?**

No. ISO returns date and time text such as 2026-09-09T12:34:56, without a Z suffix or timezone offset. Don't read that string as stating a timezone.

### Prepare your data. Build it in Strata.

Strata opens in your browser, with no account.

[Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata) [About Strata](https://oplema.com/strata)
