Home Forums SQL Server 7,2000 T-SQL Convert smalldatetime to int RE: Convert smalldatetime to int
Sergiy
SSC Guru
Points: 110206
More actions
May 14, 2015 at 6:52 pm
#1798049
DATEDIFF(dd, 0, [smalldatetime column]) + 1
_____________Code for TallyGenerator