Cast syntax to convert a sum to float

sql postgresql casting type-conversion postgresql-9.3
MAK picture MAK · Feb 26, 2015 · Viewed 78.1k times · Source

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 at or near "SUM"

My second attempt:

SELECT to_float(SUM(Seconds))/-1323 AS Averag;

Gives me this error:

 function to_float(bigint) does not exist

Answer

Erwin Brandstetter picture Erwin Brandstetter · Mar 18, 2015

There is also the shorthand cast syntax:

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

Related questions

Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL

I want to extract just the date part from a timestamp in PostgreSQL. I need it to be a postgresql DATE type so I can insert it into another table that expects a DATE value. For example, if I have 2011/05/26 09:00:00, …

Read More
How do I cast a string to integer and have 0 in case of error in the cast with PostgreSQL?

In PostgreSQL I have a table with a varchar column. The data is supposed to be integers and I need it in integer type in a query. Some values are empty strings. The following: SELECT myfield::integer FROM mytable yields …

Read More
Subtracting 1 day from a timestamp date

I am using Datagrip for Postgresql. I have a table with a date field in timestamp format (ex: 2016-11-01 00:00:00). I want to be able to: apply a mathematical operator to subtract 1 day filter it based on a time window …

Read More