Format a number

[FunkyBunch]

Hello All,

I am trying to format a date to have no decimals. I am not sure if there is a function I can use.

Select weightulw_fw --want to show with no decimals
from vehicles

Thanks y'all

 

[gmmastros]

Run this...

Select Data_Type 
From   Information_Schema.Columns
Where  table_name = 'vehicles'
       And Column_Name = 'weightulw_fw'

Post the response here. Essentially, the answer to your question depends on the data type.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SQLBill]

Also, would help to show a sampling of your date values.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875