CODEWITHSUNDEEP
azurestreamazure-sql-databaseazure-stream-analyticsstream-analytics
krishna bh
krishna bh

Reputation: 91

Cast String to date time in Stream analytics Query

We are sending datetime as string in the format 2018-03-20 10:50:037.996, and we have written Steam analytics query as below.

SELECT
    powerscout.Device_Id AS PowerScout,
    powerscout.[kW System],
    CAST(powerscout.[TimeStamp] AS datetime) AS [TimeStamp]
INTO
    [PowergridView]
FROM
    [IoTHubIn]

When we are sending data through Stream analytics, Job is getting failed. Any Suggestions please.

Thanks In Advance

Upvotes: 1

Views: 867

Answers (1)

Konstantin Zoryn
Konstantin Zoryn

Reputation: 621

ASA can parse DATETIME fields represented in one of the formats described in ISO 8601. This format is not supported. You can try using custom JavaScript function to parse it.

Upvotes: 1

Related Questions