Sql Query Expert!

itHighway · June 5th, 2005, 03:37 PM

Hello!

I need to implement "GROUP BY" sql statement on Date. The date stored in database is in '6/2/2005 4:42:36 PM' format and I want to implement "GROUP BY" only on '6/2/2005' part of date.

Any idea..
Any Help...

Will really be appriciated

Thank you,
Zeeshan Ahmed

Month(date)

om_prakash · June 5th, 2005, 11:00 PM

Hi,

One possible solution could be to convert date to varchar and then use group by.

Example:

select convert(varchar(10),date_created,101) from table_name group by convert(varchar(10),date_created,101)

This will give u data group by date, excluding time.

Om Prakash