Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql text to decimal

SELECT CAST(colName AS DECIMAL(10,2))
FROM tableName
Comment

PREVIOUS NEXT
Code Example
Sql :: how to open postgresql in mac 
Sql :: show all sequence in postgresql 
Sql :: configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path 
Sql :: drush sql-dump 
Sql :: customer using hdfc bank sql query 
Sql :: mysql allow remote connections 
Sql :: oracle sql log to console 
Sql :: oracle table statistics last analyzed 
Sql :: check if mysql is installed 
Sql :: oracle create_program 
Sql :: start mysql server 
Sql :: postgresql convert text to float 
Sql :: mysql slave status 
Sql :: sql server cast date dd/mm/yyyy 
Sql :: how to get non distinct values in sql 
Sql :: sql eliminare un record 
Sql :: mysql select greater than yesterday 
Sql :: oracle alter sequence nextval 
Sql :: reset auto increment sql server 
Sql :: postgresql reset auto_increment index 
Sql :: autocommit mysql 
Sql :: django sqllite config 
Sql :: error code 1292 mysql workbench 
Sql :: mysql reset auto increment 
Sql :: oracle nls session 
Sql :: postgresql make each element in array distinct 
Sql :: ddl materialized view 
Sql :: mysql show all tables 
Sql :: how to install sqlite3 python 
Sql :: v$session not found in oracle 
ADD CONTENT
Topic
Content
Source link
Name
2+5 =