How to create date and time for your sensors in azure sql query?

Question

Hi team&nbsp;Does any mate knows how to create date and time in your sensors like humidity/temperature? I have the following in my azure sql query editor, it does not produce date and time for my sensors in my power bi dataset.&nbsp;SELECT*INTO[PowerBIVisualizationOutput]FROM[PowerBIVisualizationInput] CS1 TIMESTAMP BY CallRecTime Kindly please help to adjust this more if possible, thanks.

v-frfei-msft · Answer

Hi&nbsp;Anonymous ,
&nbsp;
Hope this case can help you.
https://www.codeproject.com/Questions/5248360/Create-date-and-time-in-azure-SQL-query-for-your-s
&nbsp;

Forum Discussion

How to create date and time for your sensors in azure sql query?

1 Reply

Related content

Pushing data from Temperature sensor to Event stream via Logic apps

Automate creating new queries ...

Create custom query in Desktop

Creating relationships

Create Relationships in Power Query