remove time from getdate() using SQL

Question

I was wondering if anyone new how to remove the time hh,mm,ss from the getdate? I am very new to using SQL and am having trouble. Right now I have the date added so it could always pull the current date and add one day to that. Now I need to remove the time from being shown completely. I do NOT want to change time to 00:00:00, I want it to be completely hidden.

Here is my code:

Select DATEADD(DAY, 1, GETDATE())

sql server? - CAST() the result to DATE – Alex K. Jul 17 '17 at 12:53 — Alex K., Jul 17 '17 at 12:53

Rokuto · Answer 1 · 2017-07-17T12:57:43.980

3

Use CAST or CONVERT.

Using CAST

SELECT DATEADD(DAY,1,CAST(GETDATE() as date))

Using CONVERT

SELECT DATEADD(DAY,1,CONVERT(date,GETDATE()))

edited Jul 17 '17 at 12:57

answered Jul 17 '17 at 12:54

Rokuto

814
1
11
16

3

If you give 2 answers, then give 2 examples to justify your answer. – SS_DBA Jul 17 '17 at 12:55
@WEI_DBA you are right. I've edited answer. Thanks. – Rokuto Jul 17 '17 at 12:58

remove time from getdate() using SQL

1 Answers1