Sunday, January 30, 2011

Get Date Only from DateTime

Simple Conversion to nvarchar can be used to get only Date part from date and time string like

SELECT CONVERT(NVARCHAR(10),GETDATE(),120)

No comments:

Post a Comment