Here is my datetime field: system.timestamp with value `2019-10-22T08:00:22.4994430Z`

I am looking for query in Azure Stream Analytics to convert datetime from one field (system.timestamp) to 2 fields (NewDate and NewTime).

NewDate would become 2019-10-22, NewTime would become 08:00

I have tried many queries but non of them work as expected, the closest was:

```
SELECT DATETIMEFROMPARTS(DATEPART(year,[EventEnqueuedUtcTime]),DATEPART(month,[EventEnqueuedUtcTime]),DATEPART(day,[EventEnqueuedUtcTime]),00,00,00,00) AS newdate

```

But result is `2019-10-22T00:00:00.0000000Z`

There are still time with 0s and have not gone further for time

```
SELECT
    DATETIMEFROMPARTS(DATEPART(year,[EventEnqueuedUtcTime]),DATEPART(month,[EventEnqueuedUtcTime]),DATEPART(day,[EventEnqueuedUtcTime]),00,00,00,00)
AS newdate
INTO
    table1
FROM
    esp32

```