Return date only from datetime - SQL Snipplr Social Repository

Revision: 21177

at December 6, 2009 00:21 by nivlam

Initial Code

Select Cast(Floor(Cast(Getdate() As Float))As Datetime)

Select DateAdd(Day, 0, DateDiff(Day, 0, Getdate()))

Initial URL

Initial Description

Initial Title

Return date only from datetime

Initial Tags

Initial Language

SQL