How to create date and time in azure sql database query?

Question

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.