cast as date sql code example

Example 1: sql cast as

CAST('2006-04-25T15:50:59.997' AS date) AS Date,  

CAST('2006-04-25T15:50:59.997' AS time) AS Time,  

CAST('2006-04-25T15:50:59.997' AS datetime) AS Datetime,

Example 2: sql cast date

DECLARE @counter INT = 0
DECLARE @date DATETIME = '2006-12-30 00:38:54.840'

CREATE TABLE #dateFormats (dateFormatOption int, dateOutput nvarchar(40))

WHILE (@counter <= 150 )
BEGIN
   BEGIN TRY
      INSERT INTO #dateFormats
      SELECT CONVERT(nvarchar, @counter), CONVERT(nvarchar,@date, @counter) 
      SET @counter = @counter + 1
   END TRY
   BEGIN CATCH;
      SET @counter = @counter + 1
      IF @counter >= 150
      BEGIN
         BREAK
      END
   END CATCH
END

SELECT * FROM #dateFormats