Mart

← Customer Feedback for ACE Community Tooling

My feedback

  1. Add a simple Datetime format function

    46 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →
    Mart commented  · 

    This is old, but I too had a similar struggle.
    CAST(CAST(event.TimeStamp as datetime) as nvarchar(MAX))

    I used this to with concat to create a row key, it gives the output:
    2017-05-25T18:53:06.6638136Z

    instead of a "2017/05/25 06:53:06 PM"

    might save someone 5 mins

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice