Viewing 2 posts - 1 through 2 (of 2 total)
select right(convert(varchar(18),getdate(),100),7)
Is that right?
November 3, 2009 at 11:21 pm
#1074687
This can do
declare @mpr as decimal(8,8)
set @mpr = convert(decimal(8,8), 90*1.0/407)
select @mpr
October 29, 2009 at 1:01 am
#1072258