Documentation

    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.

    The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.

    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.

    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
    FormatExample valueUse it for
    UNIXVARCHAR1788957296000Milliseconds since the Unix epoch, returned as text. Convert to a number before doing numeric arithmetic.
    ISOVARCHAR2026-09-09T12:34:56A readable date and time to the second. This string has no Z suffix or timezone offset.
    DATEDATE2026-09-09The calendar date, without a time of day. Use it when the day is the level of detail you need.
    TIMETIME12:34:56The current time of day in UTC, without a date.
    TIMESTAMPTIMESTAMP2026-09-09 12:34:56A typed date and time for downstream date calculations. The value can include fractional seconds.
    TIMESTAMP WITH TIME ZONETIMESTAMP WITH TIME ZONE2026-09-09 12:34:56+00Dates 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.