showing datetime field w/o time portion

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

SSC Guru

Points: 294069

October 4, 2005 at 11:53 am

Select dateadd(D, 0, Datediff(D, 0, GetDate()))

Farrell Keough SSCoach Points: 17414 More actions · Answer 2

Or this: SELECT CONVERT( varchar, GETDATE(), 101)

I wasn't born stupid - I had to study.

rfrancisco Mr or Mrs. 500 Points: 544 More actions · Answer 3

Here's a link that will give you other ways of getting just the date part of a DateTime data type:

Gabor Nyul SSCrazy Eights Points: 9459 More actions · Answer 4

Here is an another approach:

declare @d datetime

set @d = getdate()

select cast(cast(@d-0.5 as int) as datetime)

This is almost equivalent to

select CAST(FLOOR(CAST(@d AS DECIMAL(12, 5))) AS DATETIME)

Bye
Gabor