Writing SQL to U-SQL Query
<p>Can anybody please guide me in writing this below SQL in U-SQL language used in Azure Data Lake</p>

<pre><code>select tt.userId, count(tt.userId) from (SELECT userId,count(userId) as cou
  FROM [dbo].[users]

  where createdTime&gt; DATEADD(wk,-1,GETDATE())

   group by userId,DATEPART(minute,createdTime)/5) tt group by tt.userId
</code></pre>

<p>I don't find the DATEPART function in U-SQL . Azure Data Analytic job is giving me error.</p>