Sql cast

Sql cast

-- Specifically for Oracle

-- EXAMPLE
CAST('732.98' AS INT)

/* SYNTAX
CAST(<value_to_cast> AS <data_type_to_cast_to>)
*/

14

Cast in sql server

-- For Sql server
SELECT CAST(25.65 AS int);
/*
CAST(<value_to_cast> AS <data_type_to_cast_to>)
*/

0

Similar codes

0 vote59 views1 answer
Mssql view column data type
SQL
1 vote107 views2 answers
Sql select only row with the max date
SQL
0 vote112 views1 answer
Enable sql server full text indexing
SQL
0 vote105 views1 answer
How to get inserted id in sql server
SQL
4 votes143 views1 answer
How to check last gather stats on table in oracle
SQL
1 vote105 views1 answer
Increasing font and zooming in mysql workbench
SQL
38 votes164 views4 answers
Count sql
SQL
1 vote91 views1 answer
Delete triger pl pg sql
SQL
0 vote96 views1 answer
Sql server whoami
SQL
0 vote104 views1 answer
Alter precision
SQL

Share