How to get just the date part of getdate

Question

I have a SQL table that has a CreationDate field   I have getdate   in the computed column specification formula   I would like to know how to get just the date portion  that is   2012-08-24  instead of  2012-08-24 10 45 17 740

User · Accepted Answer

If you are using SQL Server 2008 or later  select convert date  getdate      Otherwise  select convert varchar 10   getdate   120

User · Answer

SELECT CONVERT date  GETDATE

User · Answer

SELECT CAST FLOOR CAST GETDATE   AS float   as datetime    or  SELECT CONVERT datetime FLOOR CONVERT float GETDATE

User · Answer

try this   select convert  date  getdate      or  select CAST  getdate   as DATE    or  select convert varchar 10   getdate   121

User · Answer

Try this   SELECT CONVERT date  GETDATE

[sql-server] How to get just the date part of getdate()?

Examples related to sql-server

Examples related to tsql