Dates without times

[Paul Ross]

Anyone know of an easy way to work with datetime columns ignoring the time part.

I want to "group by" the date so it is vital that the time part goes.

But I still want to work with the resulting date as a date (i.e. use date functions) so I would prefer to keep the datetime data type.

[Jonathan Yang]

On 7/27/98 10:45:11 AM, Paul Ross wrote:
> Anyone know of an easy way to work with datetime columns ignoring the time
> part.

I want to "group by" the date so it is vital that the time part
> goes.

But I still want to work with the resulting date as a date (i.e.
> use date functions) so I would prefer to keep the datetime data type.


Use "group by DATEDIFF(day, date_field, "1/1/1900")" OR "group by DATEPART(year, date_field),DATEPART(month, date_field),DATEPART(day, date_field)"


good luck