MS SQL Server -How to remove leading zero from a number.

Cast the number as int.

select cast (columnsWithLeadingZeros as int) from yourTable

How to Remove/Truncate Time Part from DateTime stamp

select DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0)

or

select CONVERT(DATE, getdate(), 101)

or

SELECT CONVERT(DATE,GETDATE())

or

SELECT CAST(FLOOR(CAST(getdate() AS FLOAT)) AS DATETIME)