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:

      20180722181428

      20180722181429

      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