Thursday, October 21, 2010

Convert Date to String in SQL Server

DECLARE @Dt as DateTime
SET @Dt = '2010-04-27 11:30:17'
SELECT CONVERT(CHAR(8), @Dt, 112) +
REPLACE(CONVERT(CHAR(8), @Dt, 114), ':', '')
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)