convert to int postgresql or cero code example
Example 1: postgresql cast
SELECT '100'::INTEGER;
SELECT CAST ('100' AS INTEGER);
Example 2: cast as decimal postgresql
cast (Non_Updated as decimal) / Total_Devices AS Percent_Failure
SELECT '100'::INTEGER;
SELECT CAST ('100' AS INTEGER);
cast (Non_Updated as decimal) / Total_Devices AS Percent_Failure