File with Datetime

• hoseam

  SSCertifiable

  Points: 5533

  More actions

  September 22, 2017 at 7:34 am

  #151599

  Hi,

  I have a value stored in a column, which is the name of the file and time. e.g 

  Generic20170913100320.csv

  I want to write a Select Statement to select only a date time from this value.

• Thom A

  SSC Guru

  Points: 99133

  More actions

  September 22, 2017 at 7:54 am

  #1960495

  This appears to be a duplicate of https://www.sqlservercentral.com/Forums/FindPost1898512.aspx

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Jeff Moden

  SSC Guru

  Points: 1004406

  More actions

  September 23, 2017 at 11:48 am

  #1960621

  Thom A - Friday, September 22, 2017 7:53 AM

  This appears to be a duplicate of https://www.sqlservercentral.com/Forums/FindPost1898512.aspx

  Agreed.... no posts here, please.  Instead, click on the link Thom provided and lets keep going on a show already in progress.  Thanks.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)