Cast Syntax To Convert A Sum To Float

Using PostgreSQL 9.3, I want to convert the calculated values to data type float. My first attempt: SELECT float(SUM(Seconds))/-1323 AS Averag; Gives me this error: syntax error

Solution 1:

I use the shorthand cast syntax almost everywhere:

SELECT sum(seconds)::float / -1323 AS averag;

More details:

• Postgres data type cast

Solution 2:

You need to use the cast syntax:

SELECTCAST (SUM(Seconds) ASFLOAT)/-1323AS Averag;

Solution 3:

It is not exact casting but a trick to do the job :) and works almost in any language.

SELECT SUM(Seconds)/-1323.0 AS Averag;

OR

SELECT SUM(Seconds)*1.0/-1323 AS Averag;