PostgreSQL using to_char with floor

Question

Ok I am converting from SQL Server to PostgreSQL. I am having trouble with some to_char.

CASE LENGTH(LTRIM(RTRIM(to_char(floor(_FloatValue)))))
    WHEN 1 THEN '0' || LENGTH(LTRIM(RTRIM(TO_CHAR(floor(_FloatValue))))) || ':'
    ELSE LENGTH(LTRIM(RTRIM(TO_CHAR(FLOOR(_FloatValue))))) || ':'

I'm getting this error

   [2015-11-10 15:40:20] [42883] ERROR: function to_char(double precision) does not exist
   Hint: No function matches the given name and argument types. You might need to add explicit type casts.
   Where: PL/pgSQL function formatfloattohoursminutes(double precision) line 10 at RETURN

Any help would be great.

1) Show sql server code 2) Tell what it do

Lukasz Szozda
– Lukasz Szozda

2015-11-11 15:48:24 +00:00
Commented Nov 11, 2015 at 15:48 — Lukasz Szozda
– Lukasz Szozda, Commented Nov 11, 2015 at 15:48

Clodoaldo Neto · Accepted Answer · 2015-11-11 16:02:30Z

1

It looks like you want to left pad with zeros:

select to_char(_FloatValue, '09.99');

http://www.postgresql.org/docs/current/static/functions-formatting.html#FUNCTIONS-FORMATTING-TABLE

http://www.postgresql.org/docs/current/static/functions-formatting.html#FUNCTIONS-FORMATTING-NUMERIC-TABLE

answered Nov 11, 2015 at 16:02

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL using to_char with floor

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related