• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Is It Time To Stop Using IsNumeric()?

June 25, 2017   BI News and Info
word image 51 Is It Time To Stop Using IsNumeric()?

SELECTDateString,

   Try_Parse(DateStringASdatetime2USING‘en-Uk’)AStryParse,

   Try_Convert(DATETIME2,DateString)ASTryConvert,

   Coalesce(

   Try_Convert(DATETIME2,DateString,0),  Try_Convert(DATETIME2,DateString,1),Try_Convert(DATETIME2,DateString,2),

   Try_Convert(DATETIME2,DateString,3),Try_Convert(DATETIME2,DateString,4),Try_Convert(DATETIME2,DateString,5),

   Try_Convert(DATETIME2,DateString,6),Try_Convert(DATETIME2,DateString,7),Try_Convert(DATETIME2,DateString,8),

   Try_Convert(DATETIME2,DateString,9),Try_Convert(DATETIME2,DateString,10),Try_Convert(DATETIME2,DateString,11),

   Try_Convert(DATETIME2,DateString,12),Try_Convert(DATETIME2,DateString,101),Try_Convert(DATETIME2,DateString,102),

   Try_Convert(DATETIME2,DateString,103),Try_Convert(DATETIME2,DateString,104),Try_Convert(DATETIME2,DateString,105),

   Try_Convert(DATETIME2,DateString,106),Try_Convert(DATETIME2,DateString,107),Try_Convert(DATETIME2,DateString,108),

   Try_Convert(DATETIME2,DateString,109),Try_Convert(DATETIME2,DateString,110),Try_Convert(DATETIME2,DateString,111),

   Try_Convert(DATETIME2,DateString,112),Try_Convert(DATETIME2,DateString,113),Try_Convert(DATETIME2,DateString,114),

   Try_Convert(DATETIME2,DateString,120),Try_Convert(DATETIME2,DateString,121),Try_Convert(DATETIME2,DateString,126),

   Try_Convert(DATETIME2,DateString,127),Try_Convert(DATETIME2,DateString,130))

From

(values(N‘Jun 23 2017  3:57PM’),(N’06/23/17′),(N‘17.06.23’),(’23/06/17′),(N‘23.06.17’),

  (N’23-06-17′),(N’23 Jun 17′),(N‘Jun 23, 17′),(N’15:57:54′),(N‘Jun 23 2017  3:57:54:810PM’),

  (N’06-23-17′),(N’17/06/23′),(N‘170623’),(N‘Jun 23 2017  3:57PM’),(N’06/23/2017′),

  (N‘2017.06.23’),(N’23/06/2017′),(N‘23.06.2017’),(N’23-06-2017′),(N’23 Jun 2017′),

  (N‘Jun 23, 2017′),(N’15:57:54′),(N‘Jun 23 2017  3:57:54:810PM’),(N’06-23-2017′),

  (N‘2017/06/23′),(N‘20170623’),(N’23 Jun 2017 15:57:54:810′),(N’15:57:54:810′),

  (N‘2017-06-23 15:57:54′),(N‘2017-06-23 15:57:54.810′),(N‘2017-06-23T15:57:54.810′),

  (N‘2017-06-23T15:57:54.810′),(N’29 رمضان 1438  3:57:54:810PM’)

)sample(dateString)

Let’s block ads! (Why?)

SQL – Simple Talk

IsNumeric, Stop, Time, using
  • Recent Posts

    • Accelerate Your Data Strategies and Investments to Stay Competitive in the Banking Sector
    • SQL Server Security – Fixed server and database roles
    • Teradata Named a Leader in Cloud Data Warehouse Evaluation by Independent Research Firm
    • Derivative of a norm
    • TODAY’S OPEN THREAD
  • Categories

  • Archives

    • April 2021
    • March 2021
    • February 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited