Answers for "Cast and convert in sql"

SQL
9

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,
Posted by: Guest on August-25-2020
0

sql convert

-- CAST Syntax:  
CAST ( expression AS data_type [ ( length ) ] )  
  
-- CONVERT Syntax:  
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
Posted by: Guest on February-08-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language