Unix Timestamps

[Eric Kok]

What is the most effective way of converting those into usable dates? I have a ton of them.

Eric

[Vinoth Srinivasan]

Hi Eric 

 

Thanks for your interest in Syncfusion Components. 

 

You can convert the Unix TimeStamps values as Date values using the following expression in our report designer. 

 

=DateAdd("s",Fields!TimeStamp.Value,"1970-01-01 00:00:00") 

 

We have prepared a sample report based on this and it can be downloaded from the following location. 

http://www.syncfusion.com/downloads/support/forum/130988/ze/UnixTimeStamp-984709892 

 

Also, please refer the below MSDN forum for more details. 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/93197fb6-8ee2-4808-9da4-77b9f0c8ad38/convert-unix-timestamp-in-a-report-in-report-builder?forum=sqlreportingservices 

 

Regards, 

Vinoth S. 

[Eric Kok]

Vinoth, 

My posting was not complete, I guess. I am using the Dashboard Designer. I don't seem to have the option to use the DateAdd formula anywhere. Am I overlooking something?

Eric 

[Umapathy Shanmugam]

Hi Eric, 

 

Thanks for your reply.  

 

Could you please let us know the following details, so that we can understand your query better and provide a solution. 

1. Connection type which you are using.
2. Are you expecting to convert the string column which is in date format to date time column.
3. Provide some details about your requirement.

 

If you need to convert your string column to date time column in your dropped table we have “Change column type” option in column settings. Please refer to the below link to know more about handling column type conversion in our dashboard application.  

https://help.syncfusion.com/dashboard-platform/dashboard-designer/transforming-data/formatting-column#handling-column-type-conversion  

 

Regards, 

Umapathy S. 

[Eric Kok]

1. Connection type is ODBC.
2. Are you expecting to convert the string column which is in date format to date time column. The content is a UNIX timestamp, so the system sees it as a number and I would like to convert it somehow to a date. E.g.: Timestamp: 1497855166
3. I would like to use those timestamps as date in the Dashboards. 

[Umapathy Shanmugam]

Hi Eric, 

 

Thank you for sharing the requested details.  

 

We assumed that you are using MySQL as ODBC server type and follow the below steps to convert UNIX timestamp as date through expression designer window.  

 

Create expression like below to convert UNIX timestamp to date.  

 

S.No	Expression Name	Expression	Comments
	Expression1	FROM_UNIXTIME('1497855166')	Convert 1497855166 this time stamp value as date
	Expression2	FROM_UNIXTIME([UnixTimeStampColumn])	Convert UnixTimeStampColumn value as date

 

Now both Expression1 and Expression2 will act as date field and we can use it in widgets. Please refer the below link to know more about expression creation.  

https://help.syncfusion.com/dashboard-platform/dashboard-designer/transforming-data/configuring-expression-columns#adding-an-expression-column  

 

Please do let us know if you required any other assistance.  

Regards, 

Umapathy S. 

[Alexey Dovgan]

This is does not work with REST Web Data Source.

[Anandaraj Radhakrishnan]

Hi Alexey, 

 

Mentioned conversion process in our previous reply of this forum was particularly suggested for ODBC MySQL data source and it won’t work for web data source. So, we are suggesting you to use the below provided expression for web data source.  

 

Create expression like below to convert UNIX timestamp to date.    

 

S.No	Expression Name	Expression	Comments
1	Expression1	datetime('1497855166','unixepoch', 'localtime')	Convert 1497855166 this time stamp value as date
2	Expression2	datetime([UnixTimeStampColumn],'unixepoch', 'localtime')	Convert UnixTimeStampColumn value as date

  

Now both Expression1 and Expression2 will act as date field and then we can use it in widgets. Please refer the below link to know more about expression creation.   

https://help.syncfusion.com/dashboard-platform/dashboard-designer/transforming-data/configuring-expression-columns#adding-an-expression-column    

  

Please do let us know if you require any further assistance.   

 

Regards,
Anandaraj R 

[Malcolm van Staden]

Hi,

We have tried to make use of datetime('1497855166','unixepoch', 'localtime') in order to convert our timestamp values to datetime values. But the expression column isn't being seen as a datetime but rather as string. How can we go about resolving this?

[Dhivyabharathi Govindaraj]

Hi Eric, 

 

In our Designer, while connecting Files type and Web data source connections we have processed those data’s in in-memory and moved those data internally into SQLite server for dashboard functionalities. Later we have queried the SQLite server for all dashboard interactions. Please refer below documentation, https://help.syncfusion.com/dashboard-platform/dashboard-designer/connecting-to-data/classification-of-data-sources-queried-directly-and-in-memory  

 

SQLite Database doesn’t support Date data type. So even though you are using datetime function in your expression, it will return the result in string type.  

 

We suggest you to your expression in String type itself in your dashboard since SQLite database won’t support Date time data type.  

 

Kindly let us know if you need any further assistance. 

 

Thanks, 

Dhivya