Home Forums SQL Server 2005 Development select from GETDATE()? RE: select from GETDATE()?
Madhivanan-208264
SSCertifiable
Points: 7516
More actions
September 24, 2008 at 5:13 am
#876231
Chris Morris (9/24/2008)SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 102), '.', '')
Chris Morris (9/24/2008)
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 102), '.', '')
You dont need additional replace function
See my first reply 🙂
Failing to plan is Planning to fail