S
S
Sergey Karbivnichy2020-11-15 19:02:00
SQL
Sergey Karbivnichy, 2020-11-15 19:02:00

Is it possible to delete characters after a dot in SQL?

There is a price column. It contains prices for goods. For example: 564, 1220, 1999 - and there are such 444.3, 760.22, 990.12
Is it possible to delete everything after the period using SQL?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
L
Lazy @BojackHorseman, 2020-11-15
@hottabxp

SQL Server FLOOR() Function

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question