try_convert question to convert nvarchar to datetime

Question

Hi guys,
please can you help to convert column eventime (nvarchar) to event_time_date.
thanks in advance

Answer 1

Hi @rdboy_9727 ,

Thank you for posting query.

You can use FORMAT() function to format dates.

Similarly kind of issue addressed in below link. Kindly check it once and let us know if that helps.
https://learn.microsoft.com/en-us/answers/questions/696491/index.html

Hope this will help. Please let us know if any further queries.

------------------

Please consider hitting Accept Answer button. Accepted answers helps community as well.