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

3 votes308 views1 answer
How to check schema privileges in oracle
SQL
0 vote380 views1 answer
Mysql concatenate select results
SQL
1 vote351 views1 answer
Epoch time converter in snowflake
SQL
2 votes320 views2 answers
How to view created temporary tables in mysql
SQL
-2 votes345 views3 answers
How to fetch first 10 rows in sql
SQL
-1 vote318 views1 answer
Count occurrences sql
SQL
2 votes323 views1 answer
Columns Present in a table
SQL
3 votes327 views2 answers
Sql get month name
SQL
0 vote334 views1 answer
Connect by query in oracle
SQL
1 vote270 views1 answer
Postgres reset auto increment
SQL

Share