GetDate

[berba]

Hi, When I run the following select getdate(), I'm getting the value below: 2011-07-04 13:54:22.427 I want to get only the value 2011-07-04... Can anybody advise? Note: I don't want to convert it to varchar. Cheers

[thatraja]

berba wrote:

Note: I don't want to convert it to varchar.

:doh: Try this Get Only DateTime Part without using Convert[^]

thatraja

---

**My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
**

[Simon_Whale]

If you are using SQL Server 2008 then use the date datatype

select cast(getdate() as date)

returns 2011-07-04

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

[berba]

I'm using SQL2000

[Simon_Whale]

Without using the convert function to manipulate the date then your best answer is from thatraja

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

[Lost User]

SELECT DATEADD(dd,0,DATEDIFF(dd,0,GETDATE())) does the trick.