Unix time convert to Date in Azure stream analytics

2
votes

I'm using stream analytics to process some RFID data in realtime. The events from the RFID reader is sending to event hub as an input. Right now I'm facing a problem that the time in events is in UNIX time format, which looks like "TimeStamp":1460471242.22402," It's very strange that when I test the query(Not start the job but use the sample data from input), the UNIX time changed to "2016-04-12T14:48:00.0000000Z" , but when I start the SA job, it failed and said that the column 'timestamp' doesn't conforms to ISO 8601 standard. Is there any way to convert UNIX time to standard date format in SA without change the input raw data? My query is simple like: SELECT EPCValue, Antenna, System.TimeStamp AS Time INTO dataoutput FROM datainput timestamp by TimeStamp

1
azureazure-stream-analytics

1 Answers

3
votes

Please take a look at the sample from this page. It describes how to convert UNIX time to SQL datetime format https://msdn.microsoft.com/en-us/library/mt573293.aspx