Is there a DATE function for SQL Server? I don't want to hold the time.

A. No, just datetime, but you can strip out the time (reset it to 00:00) using :-

select convert(datetime,convert(char(10),getdate(),101))


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish