Select Only Date Part From DateTime

SELECT GETDATE()
2012-06-07 10:11:56.107


SELECT CONVERT(VARCHAR(10),GETDATE(),111)

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)