65

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

Jon Schneider
  • 25,758
  • 23
  • 142
  • 170
Rui Martins
  • 2,164
  • 7
  • 33
  • 52
  • 1
    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

5 Answers5

86

If you are using SQL Server 2008 or later

select convert(date, getdate())

Otherwise

select convert(varchar(10), getdate(),120)
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
podiluska
  • 50,950
  • 7
  • 98
  • 104
8

try this:

select convert (date ,getdate())

or

select CAST (getdate() as DATE)

or

select convert(varchar(10), getdate(),121)
Joe G Joseph
  • 23,518
  • 5
  • 56
  • 58
3

Try this:

SELECT CONVERT(date, GETDATE())
András Ottó
  • 7,605
  • 1
  • 28
  • 38
3
SELECT CONVERT(date, GETDATE())
John Woo
  • 258,903
  • 69
  • 498
  • 492
3
SELECT CAST(FLOOR(CAST(GETDATE() AS float)) as datetime)

or

SELECT CONVERT(datetime,FLOOR(CONVERT(float,GETDATE())))
Akkarapon S.
  • 31
  • 3