How to get just the date part of getdate()? [duplicate]

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'.

If you are using SQL Server 2008 or later

select convert(date, getdate())

Otherwise

select convert(varchar(10), getdate(),120)

try this:

select convert (date ,getdate())

select CAST (getdate() as DATE)

select convert(varchar(10), getdate(),121)

Try this:

SELECT CONVERT(date, GETDATE())

Related