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

[Anonymous]

Hi team

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.

SELECT

*

INTO

[PowerBIVisualizationOutput]

FROM

[PowerBIVisualizationInput] CS1 TIMESTAMP BY CallRecTime

Kindly please help to adjust this more if possible, thanks.

[v-frfei-msft]

Hi @Anonymous ,

Hope this case can help you.

https://www.codeproject.com/Questions/5248360/Create-date-and-time-in-azure-SQL-query-for-your-s