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.
Create the current time
Date/Time Now has no input. Its preview shows the value calculated when this example ran in your browser.
Date/Time Now interactive example
Loading interactive example…
The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.
| DateTimeNow |
|---|
| 2026-11-02 23:04:03.107 |
- Change Column Name to
run_atand look for the new heading in the output. - Choose
DATEin Format to keep just the calendar date. - Switch Format to
ISOorUNIXand 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.
Inputs and outputs
Inputs
0 portsNo 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.
| Format | Example value | Use it for |
|---|---|---|
| UNIXVARCHAR | 1788957296000 | Milliseconds since the Unix epoch, returned as text. Convert to a number before doing numeric arithmetic. |
| ISOVARCHAR | 2026-09-09T12:34:56 | A readable date and time to the second. This string has no Z suffix or timezone offset. |
| DATEDATE | 2026-09-09 | The calendar date, without a time of day. Use it when the day is the level of detail you need. |
| TIMETIME | 12:34:56 | The current time of day in UTC, without a date. |
| TIMESTAMPTIMESTAMP | 2026-09-09 12:34:56 | A typed date and time for downstream date calculations. The value can include fractional seconds. |
| TIMESTAMP WITH TIME ZONETIMESTAMP 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:
TIMESTAMPOptions: 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.