postgresql cast double to integer 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_FailureSELECT '100'::INTEGER;
SELECT CAST ('100' AS INTEGER);cast (Non_Updated as decimal) / Total_Devices AS Percent_Failure