Date Function Overview

  • Last update: May 15, 2025
  • Usage Position

    Date functions can be used in a New Calculation Column operator in the Data Transformation node in Data Development.

    Function List

    FunctionDescription

    DATETONUMBER - Converting a Date into a 13-Digit Timestamp

    Returns the number of milliseconds from January 1, 1970 00:00:00 GMT to the specified date.

    YEAR - Returning the Year

    Returns the year of a date.

    MONTH - Returning the Month of a Date

    Returns the month of a date. The returned value is an integer ranging from 1 (January) to 12 (December).

    WEEK - Returning the Week Number of a Year

    Returns the week number of a given date within a year.

    DAY - Returning the Day of a Date

    Returns the day of a date. The returned value is an integer ranging from 1 to 31.

    HOUR - Returning the Hour of a Time Value

    Returns the hour of a specified time value.The function specifies the returned value as an integer from 0 (0:00) to 23 (23:00).

    MINUTE - Returning the Minute of a Specified Time

    Returns the minute of a specified time. The minute is an integer ranging from 0 to 59.

    SECOND - Returning the Second of a Specified Time

    Returns the second of a specified time. The returned value is an integer ranging from 0 to 59.

    DATEDIF - Date Difference

    Returns the number of days, months, or years between two specified dates.

    NOW - The Current Time

    Returns the current time.

    ADDTODATE - Returning the Date After Adding a Specified Time Delta to a Provided Date

    Returns the date after adding a specified number of years, months, days, hours, minutes, or seconds to the provided date.

    FORMAT - Format Conversion

    Returns the specified format of a value of date.

    DATE – Displaying a Date

    Returns a specific date.

    TIME

    Returns the specified time, with the date adjusted according to the current day.

    The returned time corresponds to a numeric value ranging from 0 to 0.99999, representing the time between 0:00:00 (12:00:00 A.M.) and 23:59:59 (11:59:59 P.M.).

    TODAY - Returning the Current Date

    Returns the current date.

    TODATE - Converting to the Date Format

    Converts parameters in various date formats to date types.

    WEEKDAY - Returning the Weekday Number

    Gets the date and returns the corresponding weekday number.

    Extension

    The document provides some commonly used date combination formulas for you to use the TODATE() function directly. For details, see Common Date Formula.

     

     

     


    附件列表


    主题: Data Development - Scheduled Task
    Previous
    Next
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy