user14800447
user14800447

Reputation: 51

How to round number in PL-SQL?

I want to round a number in PL-SQL.

the number: 56.84923552

expected round: 56.849236

I want to round the 6th digit after the point. How can I do this in sql developer (PL-SQL)?

Upvotes: 1

Views: 650

Answers (1)

Aleksej
Aleksej

Reputation: 22949

You need round:

round(56.84923552, 6)

gives

56.849236

Upvotes: 3

Related Questions