How to get only the date(mm/dd/yyyy) by using the GETDATE()?

Question

Hello everyone I want to pick the current date of the system by using:

Select GETDATE()

It will give you the result

04/17/2013 06:37:35

But I just want 04/17/2013. Because I don't need the time.

Can anyone please help. Thanks in advance.

Have you tried this? SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY] — Sridevi Yedidha, Apr 17 '13 at 13:16

msmucker0527 · Accepted Answer · 2013-04-17T13:26:49.513

6

You can convert it to a DATE

SELECT CONVERT(DATE, GETDATE())

Or convert it to a VARCHAR

SELECT CONVERT(CHAR(10), GETDATE(), 101)

The 101 is the format you've requested

edited Apr 17 '13 at 13:26

answered Apr 17 '13 at 13:11

msmucker0527

3

WHy `VARCHAR(15)` and not `CHAR(10)`? The output will only ever be 10 characters exactly, so there's no need to specify more than that, and there's no reason to make it varying length. – Aaron Bertrand Apr 17 '13 at 13:22
Thanks a lot, it actually what I want. – user2289490 Apr 17 '13 at 13:23
1

@AaronBertrand lazy coding, didn't want to count! I updated it to CHAR(10). I used to use VARCHAR without specifying a length until I read your blog about what can go wrong with that – msmucker0527 Apr 17 '13 at 13:27

score 2 · Answer 2 · answered Apr 17 '13 at 13:12

2

Use this:

SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY]

For more types of date please visit here.

answered Apr 17 '13 at 13:12

Shreyos Adikari

score 1 · Answer 3 · answered Apr 17 '13 at 13:12

1

Something along the lines of:

select convert(varchar(12), GetDate(), 1)

The convert functions third parameter provides a number of different format options for date format.

answered Apr 17 '13 at 13:12

Guy Hollington

3 Answers3