This is how you will get the Date object from DateTime
SELECT CONVERT(nvarchar(20), GETDATE(), 23) AS DateOnly
For more MSSQL Convert Codes you can refer here:
http://www.dbforums.com/microsoft-sql-server/1621868-what-format-codes-mean-sql-convert.html
SELECT CONVERT(nvarchar(20), GETDATE(), 23) AS DateOnly
For more MSSQL Convert Codes you can refer here:
http://www.dbforums.com/microsoft-sql-server/1621868-what-format-codes-mean-sql-convert.html
Post a Comment