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

2 votes127 views1 answer
Update trigger
SQL
3 votes135 views2 answers
How to delete git repo locally
SQL
0 vote82 views4 answers
Sql limit 1 offset 1
SQL
0 vote159 views2 answers
Insert data into multiple tables mysql
SQL
0 vote138 views1 answer
How to install Firebird
SQL
1 vote130 views1 answer
Date_part mysql
SQL
0 vote138 views1 answer
Convert rows into columns in oracle
SQL
4 votes126 views1 answer
Wildcard in sql
SQL
0 vote121 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote145 views1 answer
Drop all data from tables
SQL

Share