Forum Discussion
Need help with transforming the Date
I have a few date fields that are coming from sql server and the data is retreived as a number and i tried to transform it to date but it is not working. I need help on how to transform th...
HI Anonymous,
Here is the expression that you can use in query editor to add a new column convert from timestamp to datetime: (you only need to repalce the field to your timestamp field names)
#datetime(1970,1,1,0,0,0) + #duration(0,0,0,[Field]/1000)In addition, you can also try to use t-SQL query to replace values when you use the data connector that allow you to use SQL statement.
Regards,
Xiaoxin Sheng
HI Anonymous,
Here is the expression that you can use in query editor to add a new column convert from timestamp to datetime: (you only need to repalce the field to your timestamp field names)
#datetime(1970,1,1,0,0,0) + #duration(0,0,0,[Field]/1000)
In addition, you can also try to use t-SQL query to replace values when you use the data connector that allow you to use SQL statement.
Regards,
Xiaoxin Sheng