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 (333)
- How to use Map Mode for Vertical Scroll Mode in Visual Studio (221)
- Find numbers with more than two decimal places in SQL (191)
- How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (190)
- Confirm before process with ASPxButton in Devexpress (189)