Extracting a Date Properly from a String.

• satnam.singh 44358

  Ten Centuries

  Points: 1300

  More actions

  June 15, 2020 at 5:45 pm

  #3763240

  If i have a string of the following format

  master_20200613220000.bak

  Then How do i display the Date as 2020-06-13 22:00:00.000

  Please Help.

   

• frederico_fonseca

  SSCoach

  Points: 16154

  More actions

  June 15, 2020 at 7:14 pm

  #3763272

  have a look in the manual for substring and convert, and potentially "stuff" - with the you will be able to do what you need.

  and if after you read the manual and tried a few examples get back to us with any questions you may still have.