Technical Article

Remove decimal places without rounding

There was a script here not too long ago which showed how to 'truncate' a number to two decimal places without rounding. This used a lot of casts to varchars and back.The solution worked, but I knew there had to be a way of doing exactly this without having to go back and forth between […]

You rated this post out of 5. Change rating

2005-08-08 (first published: )

1,464 reads

Blogs

Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables

By

Every PostgreSQL migration eventually hits the same fork in the road. The database is...

A Spread of Vacation

By

I’m off on vacation today. Which is a little weird as I just got...

How AgentDBA Identifies Backup Failures

By

Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...

Read the latest Blogs

Forums

BCA KCU BUMI SERPONG DAMAI Tlp.0817839777

By layanan_Bca88

WhatsApp Cs: 0817839777 Wisma BCA BSD City, Kav. CBD, Jl. Pahlawan Seribu Lot I.3,...

Alamat BCA KCU TANGERANG CITY Tlp.Wa:0817839777

By m4rt1n4

Bantuan,Cs : 0817825533 Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20, Jl....

Have you done a Mid year check in?

By Pat Wright

Comments posted to this topic are about the item Have you done a Mid...

Visit the forum

Question of the Day

Independence Day 2026

In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.

See possible answers