Date functions can be used in a New Calculation Column operator in the Data Transformation node in Data Development.
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.
The document provides some commonly used date combination formulas for you to use the TODATE() function directly. For details, see Common Date Formula.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy