docs/generated/temporal_functions.html

{{ $ref := ref . "maintenance/configurations.md" }}
<table class="configuration table table-bordered">
    <thead>
    <tr>
        <th class="text-left" style="width: 30%">Function</th>
        <th class="text-left" style="width: 70%">Description</th>
    </tr>
    </thead>
    <tbody>
    <tr>
        <td><h5>year(temporal-column [, precision])</h5></td>
        <td>Extract year from the input. Output is an INT value represent the year.</td>
    </tr>
    <tr>
        <td><h5>month(temporal-column [, precision])</h5></td>
        <td>Extract month of year from the input. Output is an INT value represent the month of year.</td>
    </tr>
    <tr>
        <td><h5>day(temporal-column [, precision])</h5></td>
        <td>Extract day of month from the input. Output is an INT value represent the day of month.</td>
    </tr>
    <tr>
        <td><h5>hour(temporal-column [, precision])</h5></td>
        <td>Extract hour from the input. Output is an INT value represent the hour.</td>
    </tr>
    <tr>
        <td><h5>minute(temporal-column [, precision])</h5></td>
        <td>Extract minute from the input. Output is an INT value represent the minute.</td>
    </tr>
    <tr>
        <td><h5>second(temporal-column [, precision])</h5></td>
        <td>Extract second from the input. Output is an INT value represent the second.</td>
    </tr>
    <tr>
        <td><h5>date_format(temporal-column, format-string [, precision])</h5></td>
        <td>Convert the input to desired formatted string. Output type is STRING.</td>
    </tr>
    <tr>
        <td><h5>now()</h5></td>
        <td>Get the timestamp when ingesting the record. Output type is TIMESTAMP_LTZ(3).</td>
    </tr>
    </tbody>
</table>