Hi Team
I have the following sql query database for my stream analytics jobs(inputs and ouputs). I wan to know how to create a date and time of a given day for that job when it runs? Mine is as follows, i need some guidance to able to pull this through;
- SELECT
- *
- INTO
- [PowerBIVisualizationOutput]
- FROM
- [PowerBIVisualizationInput] CS1 TIMESTAMP BY CallRecTime
Do i need to adjust this query? If so kindly please assist, thanks. The data and time dont show, why i need these be able to show on my power bi dataset.