Home Forums SQL Server 7,2000 T-SQL Help with date conversion RE: Help with date conversion
Jonathan
SSC-Insane
Points: 20427
More actions
March 10, 2004 at 3:45 pm
#498190
declare @t datetime, @h char(4)
set @t = '20040702'
set @h = '0800'
select @t, @t + STUFF(@h,3,0,':')
--Jonathan