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

If this is SQL Server, which it looks like, you should use the SQL-server tag in addition to your current tags — podiluska, Aug 24 '12 at 08:52

score 86 · Accepted Answer · edited Aug 24 '12 at 08:55

86

If you are using SQL Server 2008 or later

select convert(date, getdate())

Otherwise

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

edited Aug 24 '12 at 08:55

marc_s

answered Aug 24 '12 at 08:51

podiluska

Joe G Joseph · Answer 2 · 2012-08-24T08:55:38.073

7

try this:

select convert (date ,getdate())

or

select CAST (getdate() as DATE)

or

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

edited Aug 24 '12 at 08:55

answered Aug 24 '12 at 08:48

Joe G Joseph

score 3 · Answer 3 · answered Aug 24 '12 at 08:48

3

Try this:

SELECT CONVERT(date, GETDATE())

answered Aug 24 '12 at 08:48

András Ottó

score 3 · Answer 4 · answered Aug 24 '12 at 08:49

3

SELECT CONVERT(date, GETDATE())

answered Aug 24 '12 at 08:49

John Woo

score 3 · Answer 5 · answered May 22 '14 at 00:14

3

SELECT CAST(FLOOR(CAST(GETDATE() AS float)) as datetime)

or

SELECT CONVERT(datetime,FLOOR(CONVERT(float,GETDATE())))

answered May 22 '14 at 00:14

Akkarapon S.

5 Answers5