DATETONUMBER - Converting a Date into a 13-Digit Timestamp- FineDataLink Help Document

Last update: May 21, 2025

Overview

Syntax	DATETONUMBER(text/date)	Returns the number of milliseconds from January 1, 1970 00:00:00 GMT to the specified date.
Parameter 1	text/date	Data to be converted
Type of the Returned Value	Value

Notes

The function supports one parameter of the text or date type.

If any parameter is set to NULL, the result is NULL.

Example

Formula	Result	Note
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.

Previous：DATEDIF - Date Difference

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

Helpful
Not helpful
Only read

中文（简体）

English

DATETONUMBER - Converting a Date into a 13-Digit Timestamp

Overview

Notes

Example

附件列表