46 votesMart 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:
instead of a "2017/05/25 06:53:06 PM"
might save someone 5 mins