10 Replies Latest reply on Sep 26, 2018 12:14 PM by Gurpreet Singh Goraya

    Convert datetime string value to date and time

    Gurpreet Singh Goraya

      Hello All,


      I have a column in SQL database which shows date and time (seconds) as a single string value. The date value looks like the following:



      The first eight values show date and last six value shows time in seconds. I want to create two separate columns of Date and Time. Please advise. I would appreciate the help. Thanks