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

Neil Pike

July 27, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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))

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like