Home Forums SQL Server 2005 T-SQL (SS2K5) Converting Getdate() To Varchar RE: Converting Getdate() To Varchar
Tommy Bollhofer
SSChampion
Points: 14940
More actions
February 6, 2008 at 10:26 am
#775711
I believe 14 is what your looking for -
select replace(convert(varchar, getdate(),112),'/','') + replace(convert(varchar, getdate(),14),':','')
Tommy