MSSQL replace string function

-- SQL date & time eliminating dividing characters

------------

-- MSSQL replace string function

-- T-SQL string concatenate (+)

USE AdventureWorks2008;

SELECT replace(convert(VARCHAR(10),getdate(),102),'.','')

-- 20120315

SELECT replace(convert(VARCHAR(10),getdate(),111),'/','')

-- 20120315  

-- SQL triple replace

SELECT replace(replace(replace(convert(VARCHAR(25),

       getdate(),20),'-',''), ':',''),' ','')

-- 20120529090427

-- T-SQL concatenating from a date and a time conversion

SELECT replace(convert(VARCHAR(10),getdate(),111),'/','') +

       replace(convert(VARCHAR(8),getdate(),108),':','')

-- 20120315085654