Gcobani Mkontwana

Gcobani Mkontwana

  • 1k
  • 1.3k
  • 115.9k

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

Oct 14 2019 2:27 AM
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;
  1. SELECT  
  2. *  
  3. INTO  
  4. [PowerBIVisualizationOutput]  
  5. FROM  
  6. [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.