DATETONUMBER(text/date)
Returns the number of milliseconds from January 1, 1970 00:00:00 GMT to the specified date.
text/date
Data to be converted
Value
The function supports one parameter of the text or date type.
If any parameter is set to NULL, the result is NULL.
DATETONUMBER(TODATE("2008-08-08"))
1218124800000
For example, add a New Calculation Column operator in the Data Transformation node, and input the formula DATETONUMBER(Registration_Time) to convert the date-type data in Registration_Time data into timestamps, as shown in the following figure.
The following figure shows the result.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy