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 vote260 views1 answer
Oracle string length
SQL
0 vote233 views1 answer
Cast float mysql
SQL
0 vote242 views1 answer
How to run mysql on terminal mac
SQL
12 votes242 views2 answers
Find duplicates mysql column
SQL
0 vote243 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
3 votes256 views2 answers
Sql server current date without time
SQL
0 vote242 views1 answer
Exit psql
SQL
0 vote243 views1 answer
Postgresql interview questions
SQL
0 vote266 views1 answer
Netstat -tln mysql
SQL
2 votes241 views1 answer
Postgresql transaction
SQL

Share