SQL Server convert from string to smalldatetime

------------

-- SQL Server convert from string to smalldatetime

------------

-- T-SQL convert from format mm/dd/yyyy to smalldatetime

SELECT CONVERT(smalldatetime, '10/23/2016', 101)

-- 2016-10-23 00:00:00

-- MSSQL convert from format dd/mm/yyyy to smalldatetime

SELECT CONVERT(smalldatetime, '23/10/2016', 103)

-- 2016-10-23 00:00:00

-- Month 23 is out of range

SELECT CONVERT(smalldatetime, '23/10/2016', 101)

/* Msg 242, Level 16, State 3, Line 1

The conversion of a varchar data type to a smalldatetime data type resulted

in an out-of-range value.

*/

------------

-- Translate/convert string/text hours and minutes to seconds

------------

DECLARE @TimeStr varchar(16) = '20:49:30'

SELECT   PARSENAME(REPLACE(@TimeStr,':','.'),1)

       + PARSENAME(REPLACE(@TimeStr,':','.'),2) * 60

       + PARSENAME(REPLACE(@TimeStr,':','.'),3) * 3600

-- 74970

------------