Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
DECLARE @tTemp1 TABLE (iID INT IDENTITY(1,1) PRIMARY KEY,
dDateTime DATETIME)
INSERT INTO @tTemp1(dDateTime)
VALUES('2008-01-05')
INSERT INTO @tTemp1(dDateTime)
VALUES('2008-01-06')
INSERT INTO @tTemp1(dDateTime)
VALUES('2008-01-07')
SELECT CONVERT(NVARCHAR(10), dDateTime, 101)AS 'TimeToChar' FROM @tTemp1
DECLARE @tTemp2 TABLE (iID INT IDENTITY(1,1) PRIMARY KEY,
sDateTime NVARCHAR(10))
INSERT INTO @tTemp2(sDateTime)
VALUES('2008-01-05')
INSERT INTO @tTemp2(sDateTime)
VALUES('2008-01-06')
INSERT INTO @tTemp2(sDateTime)
VALUES('2008-01-07')
SELECT CONVERT(DATETIME, sDateTime, 101)AS [CharToTime]FROM @tTemp2