SELECT CONVERT(DATE, GETDATE())
Tag: return
How to return only the Date from a SQL Server DateTime datatype
–You can change GETDATE() with the date you want to use SELECT CONVERT(date, GETDATE())
Recent Posts
Most Viewed Posts
- Get the First and Last Word from a String or Sentence in SQL (245)
- How to use Map Mode for Vertical Scroll Mode in Visual Studio (195)
- How to make some specific word(s) Bold or Underline in ReportViewer (187)
- How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (183)
- Confirm before process with ASPxButton in Devexpress (173)