Unix Timestamp
Unix timestamp is a method to convert dates into seconds, milliseconds, microseconds and nanoseconds. For eg., 11-11-2022 is 1668160800000 (in milliseconds). This count starts at the Unix Epoch on January 1st, 1970 at UTC. Therefore, the unix timestamp is merely the number of seconds between a particular date and the Unix Epoch.
It must be noted that a certain point in time technically does not change no matter where you are located on the globe. This is very useful to computer systems for tracking and sorting dated information in dynamic and distributed applications both online and client side.
Tip: You can use the Epoch and Unix Timestamp conversion tool shown below to check the accuracy of the date calculations.
1. Fill Derived Field Form
Go to the Derived Fields menu item. A form will show up like below to create a New Derived field. Give a name to this field. Fill the details for the form.
1.1 Select the Type
Next, you would find a dropdown in the Select Method Type.
1.2 Choose the Date Format
From the dropdown choose Date Format to get a derived field. For eg.dd-mm-yy i.e., 11-11-2022
1.3 Make the Selection
Select milliseconds for Unix Timestamp.
2. Display the Derived Field Data
Choose the Show Fields option and you can get the details of the derived fields. The details will be displayed just below the button.
3. Configure the Field
Go to the components section and click on it to add let’s say, a data table to the space. You can choose a data table, data group etc., from the components section as per your requirement.
4. Bind the Data
Click on the border of the data table and you would find the circular Settings Icon . Click on it to export/ bind data from the Collections. A box will appear on doing so. Mention the name of the collection from the dropdown to export its data to this selected table.
5. Export the Data
Once all data has been imported you can click the Preview/Publish icon in the top right corner.
5.1 View the Data
It will display all data in date format for you.
