How to the get current date without the time part

Question

3.00/5 (1 vote)

See more:

SQL-Server-2008R2

In SQL Server 2005 how do I get the current date without the time part? I have been using GETDATE() but would like it to have a time of 00:00:00.

Posted 19-Apr-15 22:56pm

Unni R

Add a Solution

Comments

Maciej Los 20-Apr-15 5:16am

SQL Server 2005 or 2008?

5 solutions

Solution 3

Solution 1 by _Canny_Brisk_[^] is very good and recommended to you, if you use SQL Server 2008 and up. In addition to it (just in case you use SQL Server 2005), try this:

SQL

SELECT DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0)

Source: Best approach to remove time part of datetime in SQL Server[^]

Posted 19-Apr-15 23:14pm

Maciej Los

Updated 19-Apr-15 23:16pm

v2

Comments

Joezer BH 20-Apr-15 5:19am

5+2 U 2!

Ha - We've updated the solution for SQL 2005 simultaneously

Maciej Los 20-Apr-15 5:22am

Thank you ;)
I see it now ;)

Solution 4

Above solution is very good and you can also use this as like an alternate ---

Only for date-

select CONVERT(varchar(10), getdate(), 120)AS coDate1

output-- 2015-04-20

Only for time

select CONVERT(varchar(10), getdate(), 108)AS coTime1

output-- 14:42:35

Posted 19-Apr-15 23:16pm

upendra shahi

Updated 19-Apr-15 23:22pm

v2

Solution 5

SQL

use this . 

select cast(GETDATE() as date)

Posted 21-Apr-15 2:36am

RKparmar

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Joezer BH** · Accepted Answer · 2015-04-19T23:07:00

Solution 1

You tagged the question SQL-Server-2008R2, in which case use:

SQL

Convert(date, getdate())

BUT, in the question itself you stated SQL Server 2005, in which case, use:

SQL

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

Cheers,
C

Posted 19-Apr-15 23:07pm

Joezer BH

Updated 19-Apr-15 23:16pm

v2

Comments

Maciej Los 20-Apr-15 5:14am

+5!

Joezer BH 20-Apr-15 5:17am

thank you Maciej

Maciej Los 20-Apr-15 5:19am

You're very welcome. I added my solution. Have you seen it? OP tagged question as SQL Server 2008 R2, but then He's talking about SQL Server 2005.
[EDIT]
Uppsss... I see it now, you have updated your answer. Super!

Solai Raja · Accepted Answer · 2015-04-19T23:10:00

Solution 2

Here you have clear explanation about date and converting date format

Posted 19-Apr-15 23:10pm

Solai Raja

Comments

Unni R 20-Apr-15 5:18am

I have one table its contain 3 columns name ,dep and dob . dob data type as "datetime".
select * from empmaster WHERE DOB=getdate().. its not working

Solai Raja 20-Apr-15 5:21am

Select * From empMaster Where Convert(Date,DOB) = Convert(Date,getdate())

Unni R 20-Apr-15 5:24am

error mesage "Msg 243, Level 16, State 1, Line 2
Type Date is not a defined system type.
Msg 243, Level 16, State 1, Line 2
Type Date is not a defined system type."

Solai Raja 20-Apr-15 5:33am

Select * From empMaster Where Convert(Varchar,DOB,101) = Convert(Varchar,getdate(),101)

Unni R 20-Apr-15 5:35am

Thanku .. its working