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 vote140 views1 answer
Stored procedures example
SQL
1 vote145 views1 answer
How to set up a trigger in sql
SQL
7 votes152 views5 answers
Max 3 salary in sql
SQL
23 votes140 views4 answers
How to show all users in mysql
SQL
0 vote157 views1 answer
Trigger stock phpmyadmin
SQL
2 votes154 views1 answer
Sql count having
SQL
2 votes146 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
52 votes313 views6 answers
Rename column sql
SQL
0 vote128 views1 answer
Restore backup "text" postgresql command line
SQL
1 vote150 views1 answer
UseSqlServer no definition
SQL

Share