sql server cast as date code example
Example 1: sql cast
-- Specifically for Oracle
-- EXAMPLE
CAST('732.98' AS INT)
/* SYNTAX
CAST( AS )
*/
Example 2: sql cast to integer
-- NOTE: this is for SQL-Oracle specifically
/*
<...> : Your personal entry
*/
-- syntax:
CAST( as ) -- in this case: = INTEGER
-- example:
SELECT CAST(MEMBER_NO as INTEGER)
FROM DUAL;
Example 3: 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