Looking for a JavaEE Architect or Potential Tech Co-Founder?
Please don't hesitate to contact me.

MSSQL Get the date from DateTime

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
MSSQL Get the date from DateTime MSSQL Get the date from DateTime Reviewed by Edward Legaspi on Thursday, June 16, 2011 Rating: 5

No comments:

Powered by Blogger.